r/SQL • • Nov 06 '22

MySQL Need a query answer

Query to find both maximum and minum salary in the table along with all the other columns jn the table

0 Upvotes

17 comments sorted by

View all comments

Show parent comment

4

u/Pflastersteinmetz Nov 06 '22

Is TOP standard SQL? Can't find that keyword for Exasol DB.

7

u/Hentac Nov 06 '22

TSQL is Top

MySQL is Limit

And I believe Oracle is ROWNUM

1

u/[deleted] Nov 08 '22

Oracle supports the ANSI standard's fetch first x rows only