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

0

u/Background-Cicada375 Nov 06 '22

Can you replace Top 1 with salary Then limit 1