First max salary in sql

SELECT first-name
FROM employees
WHERE salary = (SELECT MAX(salary) FROM employees);

Sql highest salary by location

/*  Highest salary by Department/Location   */
SELECT e.ename, e.sal, e.deptno, d.loc
FROM emp e
JOIN dept d
ON e.deptno = d.deptno
WHERE e.sal in
( 	
  	select max(sal) 
  	from emp 
  	group by deptno
)

Second max salary in sql

SELECT MAX(SALARY) 'SECOND_MAX' FROM EMPLOYEES
WHERE SALARY <> (SELECT MAX(SALARY) FROM EMPLOYEES);

How to get employee having maximum experience in mysql

select max(salary), dept_id from employee where salary not in(select max(salary) from employee) group by dept_id;

Source: codeproject.com

Similar codes

0 vote287 views2 answers
Close external port 3306 with iptables
SQL
0 vote279 views1 answer
Check for directory in bash
SQL
0 vote299 views1 answer
Sql date between one week
SQL
18 votes245 views2 answers
How to get all the tables displayed in oracle
SQL
15 votes277 views3 answers
Create table with primary key auto increment in sql
SQL
0 vote257 views1 answer
Metada in sql
SQL
1 vote298 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
3 votes289 views1 answer
Select database in sql
SQL
2 votes266 views1 answer
Match in sql server
SQL
0 vote299 views1 answer
Postgresql check total storage
SQL