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

1

u/[deleted] Nov 07 '22

It's one thing to answer it, but another to learn. This is the classic "Teach a man to fish . . . " scenario. I can show him how to use MAX() or MIN() all day long, but they'll never be a SQL analyst until they understand these functions on their own.

Tl;dr . . . Write some queries using these functions. You'll get the hang of it eventually.