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?

Thanks

https://www.codecademy.com/courses/sql-table-transformation/lessons/subqueries/exercises/non-correlated-ii?action=lesson_resume

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.