Sql max min

select emp_name, salary
from employees
where salary = (select max(salary) from employees)
union all
select emp_name, salary
from employees
where salary = (select min(salary) from employees);

Source: stackoverflow.com

Similar codes

15 votes308 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote145 views2 answers
How to generate a unique random number in mysql
SQL
0 vote148 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
3 votes141 views1 answer
Pl sql escape &
SQL
0 vote136 views1 answer
Sql server convert date to weekday
SQL
0 vote139 views1 answer
Désinstaller postgresql linux
SQL
0 vote144 views1 answer
How to find lowest in sql
SQL
1 vote147 views1 answer
Declare variables sql
SQL
0 vote136 views1 answer
Sql select duplicates based on two columns
SQL
0 vote137 views1 answer
Hibernate dialect property xml for mysql 8
SQL