Difference between Top and Limit Keyword in SQL

Solution 1:

If you are using SQL Server use TOP if you are using MySQL or Postgres use Limit!

AFAIK there is no product that currently supports both. Here's one list of current implementations and here's another (covers more products but in less detail)

Solution 2:

As stated in my comment for Martin Smith's answer above, there are products that support both, LIMIT and TOP (as you can see here). The difference is that TOP only selects the first n records, but LIMIT allows the definition of an offset to retrieve a specific range of records:

SELECT * FROM ... LIMIT 5 OFFSET 10

This statement selects the first 5 records, after skipping 10 records and this isn't possible with TOP.

The example I posted is only checked against the DBS I linked above. I didn't check a SQL standard, because of a lack of time.

Solution 3:

TOP & LIMIT both work on amazon Redshift

Solution 4:

limit works on MySQL and PostgreSQL, top works on SQL Server, rownum works on Oracle.

Solution 5:

There is no difference. The TOP and LIMIT keywords function identically, and will return the same thing.