/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 vote231 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote239 views1 answer
Retornar apenas o ano mysql date
SQL
1 vote202 views1 answer
Spark sql concatenate string and int
SQL
0 vote208 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote295 views1 answer
Having all mysql
SQL
0 vote200 views1 answer
Oracle exchange subpartition
SQL
0 vote194 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote218 views1 answer
Regex any word except sql
SQL
0 vote210 views1 answer
Select year from dual oracle
SQL
0 vote203 views2 answers
Oracle select
SQL

Share