本文介绍了几种SQL查询技巧，包括如何使用条件筛选、分页查询等。通过具体的SQL语句示例，如基于类别ID和价格范围的图书检索、按ID排序的前20条记录选择、特定分页查询以及区间内的记录获取，读者可以了解到实用的SQL编写方法。
select * from books
where 1=1
and categoryid=29
and title like('%ASP.NET%')
and unitprice>10
order by id
Select top 20 * from books order by id
--m:每页显示行数 n：当前页数
select Top m * from books
where id not in
(Select top m(n-1) id from books order by id)
order by id
select * from
(select Row_number() over(order by id) as num,
* from books) as table1
where num between 21 and 30
扫一扫
2891
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
