Find out nth highest salary from emp table
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal < = b.sal);
Enter value for n: 2
Showing Answers 1 - 74 of 74 Answers
- Query to get highest marks output
- Display employee select SQL query
- Etl testing
- Etl duplicate records
- Database table active records count
- Voltage without current and current without voltage
- Refresh external table
- Maximum score details among 10 records using transformer stage
- Load 1 crore records into 3 different targets having 25 l records in each?
- Etl testing - find duplicate value
- Is it true that developers are good security tester? If yes why?
- Subclass of component class
- Question on constraints
- Tronfy home cinema projector 60
- Test UNIX login
- Display previous row salary in the current row display next row salary in the current row
- Find a solution in c, c++, c#
- Find function and query find function
- What is calculating context?
- Topological sort algorithm