/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

49 votes337 views6 answers
Install mysql ubuntu
SQL
0 vote192 views1 answer
Psql list view rules
SQL
0 vote208 views1 answer
Python sqlalchemy connection show server
SQL
0 vote188 views2 answers
How to combine diff colmun value using group by postgres
SQL
10 votes202 views2 answers
Show tables in schema oracle
SQL
5 votes238 views1 answer
Mysql created at yesterdau
SQL
1 vote316 views1 answer
Oracle current sequence value
SQL
0 vote202 views1 answer
Sql doesn't contain
SQL
3 votes199 views3 answers
Mysql order by list
SQL
3 votes189 views1 answer
Oracle transaction commit rollback example
SQL

Share