/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

4 votes259 views1 answer
Oracle show error line number
SQL
19 votes281 views6 answers
Sql create table
SQL
0 vote271 views2 answers
Return the number of records in a single table mysql
SQL
1 vote254 views1 answer
Foreign key constraint in ms sql
SQL
2 votes273 views1 answer
Oracle find unusable indexes
SQL
1 vote287 views1 answer
SQL Integer devision
SQL
0 vote272 views1 answer
Casterar postgres
SQL
3 votes267 views2 answers
Sqlite show table definition
SQL
1 vote274 views3 answers
Mysql Server Start
SQL
1 vote290 views1 answer
Round function in sql oracle
SQL

Share