sql查询主要包括哪4种

sql查询主要包括以下4种：

第一种（top）：select top 10 * from dbo.Admin where Id not in(select top 10 Id  from dbo.Admin)

第二种（max）：select top 10 * from dbo.Admin where Id >

            (select Max(Id) from dbo.Admin where Id in(select top 10 Id from dbo.Admin))

第三种（between-and）：select * from dbo.Admin where Id between 11 and 20

第四种（row-number）：select * from (select *， Row_Number()over(order by Id)as number from dbo.Admin)t

                where t.number between 11 and 20