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
- Top 2 transactions per date
- Table name and trigger name
- Check manual entries in target table
- Print minimum & maximum salary of respective employee
- Write a query for split one column to multiple columns
- Salary provision
- Load a date field value from sequencial file to databse table with out using transformer
- Which table will load first - fact or dimension table?
- SQL query to convert single row from multiple tables into single row in a table
- Rrepeating element in an array of integers
- Get numbers inside all webelements in webtable and sort them
- Collections get nth record from index by table
- Find the missing number: 2, 4, 6, 8, 10, 12?
- 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