sql for dummies review

Label:Often write stored procedures, but today in the use of cursors or negligence of some things, the implementation of the process has not been carried out, and then directly linked to SQL Server, the lesson Ah! Although the code is simple, I hope to remember: Create PROCEDURE [dbo]. [TEMPHXB] As BEGIN declare @uidintDeclare mycursortemp Cursor for SelectUid fromTemptable1whereIndate>'2015-05-21'and type='1'GROUP BY UID have COUNT (*) >1Open mycurso

Label:/* A property (xx) in table t is repeated n times so record. eg: the name repeats more than 3 times in table a so record. idea: First find out more than 3 times the name of what, and then the records of these names extracted. * /select * from A where name in ( select Name Form A GROUP by name has count (name) >3 ) /* Query the nth to M Records in table a (id,name): 31st to 40th record in the table */ mysql:: Select * from A limit 30, 10; (limit in MySQL) Find the first 30 ID, and then fi