Q 1/7 instead of "limit 0,10" can I use "select top 10"?

Hi there,

At my job we use SQL and often we will select the top 1000 rows using the syntax below.

I discovered the solution to this question using limit 0,10 however I don’t see why it wouldn’t also work to use Top.

Am I using a different version of SQL at work?



Error: near line 1: near “10”: syntax error

select top 10 *
from flights;

select * from flights
limit 10;

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.