/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

0 vote198 views2 answers
Oracle select
SQL
0 vote208 views1 answer
T-SQL - Where Used List (Table/View)
SQL
1 vote202 views2 answers
How to add amount between date in sql
SQL
0 vote204 views2 answers
Mysql insert into multiple tables
SQL
7 votes191 views1 answer
Alter sequence set current value oracle
SQL
1 vote199 views1 answer
Oracle stop
SQL
0 vote204 views1 answer
Sql delete from with relation
SQL
0 vote184 views1 answer
Go install mysql
SQL
0 vote200 views1 answer
Postgres data location
SQL
0 vote208 views1 answer
WHERE not regex in SQL
SQL

Share