/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 vote369 views1 answer
Mysql get nested records
SQL
0 vote313 views1 answer
Apex for oracle 11g
SQL
8 votes291 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote312 views1 answer
Rails sql query converstion
SQL
2 votes296 views1 answer
Codeigniter print last sql query
SQL
0 vote302 views1 answer
Oracle archivelog usage
SQL
0 vote341 views1 answer
Wordpress make wp user in db
SQL
0 vote319 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote318 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote300 views1 answer
Set classpath for mysql-connector.jar
SQL

Share