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 vote143 views2 answers
How to see table associated with a schema in sql
SQL
0 vote130 views1 answer
Search In the Data using ObjectName
SQL
0 vote149 views1 answer
How to check foreign key constraint in sql
SQL
10 votes134 views2 answers
Rtrim sql
SQL
0 vote120 views1 answer
Max length found in mysql
SQL
0 vote141 views1 answer
TSQL convert csv to table
SQL
0 vote128 views1 answer
Connect to nginx server mysql remotly
SQL
1 vote117 views3 answers
Mariadb add foreign key
SQL
-1 vote129 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote131 views1 answer
Sql column contains special character
SQL