0
Can someone point out exact difference between limit and top
2 ответов
+ 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
+ 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.