sql语句 limit

limit关键字在SQL语句中用来限制查询结果的返回数量。它可以与offset关键字一起使用来指定从哪一行开始返回数据。其中，offset表示跳过的行数，limit表示展示的行数。比如，使用语句"select * from student limit 6"，表示从student表中返回前6条数据。而使用语句"select * from student limit 2,6"，表示从student表中跳过2行，从第3条开始返回6条数据，即返回第3条到第8条数据。 [1 [2 [3<em>1</em><em>2</em><em>3</em>
#### 引用[.reference_title]
- *1* *2* [sql语句limit限制查询结果行数用法](https://blog.csdn.net/cute980403708/article/details/123504790)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}} ] [.reference_item]
- *3* [SQL语句中Limit用法超级详细](https://blog.csdn.net/m0_71461928/article/details/130516567)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}} ] [.reference_item]
[ .reference_list ]