SQL分页查询

最新推荐文章于 2024-09-13 17:28:28 发布

wuyu0314

最新推荐文章于 2024-09-13 17:28:28 发布

阅读量358

点赞数

分类专栏： Interview DataBase 文章标签： sql function mysql email user

本文链接：https://blog.csdn.net/wuyu0314/article/details/4721104

版权

Interview 同时被 2 个专栏收录

9 篇文章 0 订阅

订阅专栏

DataBase

4 篇文章 0 订阅

订阅专栏

thunder:

1.MYSQL实现
mysql> select * from user;
+----+----------+----------+-----------------+
| ID | username | password | email           |
+----+----------+----------+-----------------+
| 1 | admin    | admin    | abc@yahoo.cn    |
| 2 | thomas   | 159753   | thomas@yahoo.cn |
| 3 | thomas1 | 159753   | thomas@yahoo.cn |
| 4 | huhu     | 159753   | hu@yahoo.cn     |
| 5 | fdg      | dfg      | fdg             |
| 6 | sdf      | sd       | sdf@yahoo.cn    |
| 7 | d        | d        | d@d.cn          |
+----+----------+----------+-----------------+
7 rows in set (0.00 sec)

mysql> select * from user limit 3,2;
+----+----------+----------+-------------+
| ID | username | password | email       |
+----+----------+----------+-------------+
| 4 | huhu     | 159753   | hu@yahoo.cn |
| 5 | fdg      | dfg      | fdg         |
+----+----------+----------+-------------+
2 rows in set (0.00 sec)

mysql>
===================================================
2.MSSQLServer实现
select top 5 function_id,function_name from d_function
where function_id not in (select top 5 function_id from d_function)
6 月统计
7 部门查询
8 公司查询
9 工程招标
10 工程总结