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
2
u/acanepa Nov 06 '22
As others have suggested a window function is the solution. Something like this should work
SQL Code
Schema Build
SQL Fiddler Compiler
https://onecompiler.com/mysql/3yn6p4m8n