SQL LIMIT All In One

SQL LIMIT All In One

demo

select * from cakes ORDER BY calories ASC LIMIT 3

https://www.sololearn.com/learning/eom-project/1060/1056

MySQL

SELECT column_name(s)
FROM table_name
WHERE condition
LIMIT number;

SQL Server / MS Access

SELECT TOP number|percent column_name(s)
FROM table_name
WHERE condition;

refs

https://dev.mysql.com/doc/

https://docs.oracle.com/cd/E17952_01/index.html

---

---

©xgqfrms 2012-2020

www.cnblogs.com/xgqfrms 发布文章使用：只允许注册用户才可以访问！

原创文章，版权所有©️xgqfrms, 禁止转载 🈲️，侵权必究⚠️！

---