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

-2 votes171 views2 answers
Union vs union all in sql
SQL
2 votes167 views1 answer
Oracle find constraints referencing a table
SQL
1 vote162 views1 answer
Postgres grant read only access to database
SQL
0 vote186 views1 answer
Mysql utc timestamp
SQL
0 vote171 views1 answer
Drop column from local database postgres pgadmin
SQL
1 vote235 views1 answer
Base64 encode sql server
SQL
0 vote173 views1 answer
Where name ends in SQL
SQL
0 vote165 views1 answer
Find all tables where column name exists oracle
SQL
0 vote162 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote193 views1 answer
How to enable mysql 5.7 root user password on linux
SQL