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

104 votes306 views2 answers
Like in mysql
SQL
1 vote216 views1 answer
Group_concat max length mysql
SQL
2 votes199 views1 answer
Postgresql transaction
SQL
0 vote206 views1 answer
Logtash mysql cofiguration file
SQL
0 vote243 views1 answer
How to use sqlcommand
SQL
4 votes188 views4 answers
Sqlite describe table
SQL
0 vote198 views1 answer
Get a list of tables and the primary key
SQL
0 vote200 views1 answer
Django mssql backend
SQL
0 vote168 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote184 views1 answer
Mysql show foreign keys column
SQL