/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

3 votes151 views1 answer
Oracle failed login attempts
SQL
3 votes188 views2 answers
See mysql users ubuntu
SQL
0 vote153 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote180 views2 answers
Identity column in sql server
SQL
8 votes163 views5 answers
Grant permission in postgres
SQL
0 vote154 views1 answer
How to create an SQL save method in ruby
SQL
18 votes203 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote170 views1 answer
Groupby error in mysql
SQL
0 vote288 views1 answer
How to delete duplicate rows in oracle
SQL
1 vote167 views1 answer
ALL_TAB_PARTITIONS
SQL

Share