/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 vote129 views1 answer
Deleted table in sql trigger
SQL
17 votes204 views1 answer
Selecting name that contain certain word in sql
SQL
9 votes164 views2 answers
Convert data type in sql
SQL
3 votes221 views2 answers
Synonym oracle
SQL
0 vote169 views1 answer
Close sql query vb.net
SQL
0 vote151 views1 answer
<script>alert
SQL
2 votes165 views1 answer
Sqlite show table indexes
SQL
3 votes166 views3 answers
Create table in microsoft sql server
SQL
0 vote159 views1 answer
Sql select non unique
SQL
1 vote172 views1 answer
SQL query to get all table records count from a database
SQL

Share