/SQL/Lowest salary in sql

Lowest salary in sql

N highest salary in sql

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP N salary
FROM #Employee
ORDER BY salary DESC
) AS temp
ORDER BY salary

7

Source: javarevisited.blogspot.com

Lowest salary in sql

SELECT first_name, last_name, salary, job_id
FROM employees
WHERE salary = (SELECT MIN(salary) FROM employees);

0

FIND LOWEST SALARY EARNER IN SQL

SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY = (SELECT MIN(SALARY) FROM EMPLOYEES);

0

N highest salary in sql

SELECT salary FROM Employee ORDER BY salary DESC LIMIT N-1, 1

0

Source: javarevisited.blogspot.com

Similar codes

2 votes133 views2 answers
Set database timezone mysql
SQL
4 votes125 views1 answer
Add constraint fk
SQL
2 votes129 views3 answers
How to check current user in mySQL
SQL
12 votes214 views2 answers
Find duplicates mysql column
SQL
3 votes93 views1 answer
V$session not found in oracle
SQL
1 vote212 views3 answers
Uninstall postgresql mac
SQL
1 vote150 views1 answer
Sql set auto increment back to 0
SQL
0 vote123 views1 answer
Mysql group rows with same value
SQL
1 vote171 views1 answer
Psql client write to bash variable
SQL
0 vote121 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL

Share