0

Can someone point out exact difference between limit and top

1st Nov 2018, 2:35 PM
SHAILA BHAGWAT
2 Antworten
+ 4
Doesn't look very coding to me, perhaps you're stripping off a lot of details. So SHAILA BHAGWAT please give us more details
1st Nov 2018, 3:17 PM
👑 Prometheus 🇸🇬
👑 Prometheus 🇸🇬 - avatar
+ 4
Both TOP and LIMIT are used to limit number of records returned from a SELECT query, the difference would be that TOP is implemented in MSSQL, and LIMIT is implemented in MySQL, MariaDB, and PostgreSQL. Other difference is that LIMIT allows to define an offset, from which point on the records range, data are to be returned, this isn't supported by TOP. * Some DBMS products support use of both LIMIT and TOP, such as SAP HANA and Amazon Redshift. * The same functionality in Oracle is implemented by ROWNUM specifier. [Sources] https://www.w3schools.com/sqL/sql_top.asp https://stackoverflow.com/questions/5668540/difference-between-top-and-limit-keyword-in-sql P.S. As mentioned by ⏩ Prometheus ⏪, you should have included some details to make things clear, at least specify 'SQL' in your original post tags.
1st Nov 2018, 5:49 PM
Ipang