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

0 vote203 views1 answer
Date 3 months from today sql
SQL
15 votes189 views6 answers
Psql
SQL
0 vote234 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote191 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
3 votes161 views1 answer
Difference sql vs mysql
SQL
4 votes189 views1 answer
Refresh postgres config
SQL
0 vote189 views3 answers
Between keyword sql
SQL
0 vote185 views1 answer
Left join in codeigniter query builder
SQL
0 vote195 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote234 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL