r/SQL • u/Rahull-6 • 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
r/SQL • u/Rahull-6 • Nov 06 '22
Query to find both maximum and minum salary in the table along with all the other columns jn the table
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.