Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 37980 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / gourvendra singh
In oracle you can find the 3rd max salary with the help of
the command:-
select sal from(select sal from(select distinct sal from
emp order by sal desc)
where rownum <=3 order by sal asc) where rownum=1;
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What is PL/SQL Records?
What is the difference between delete and truncate commands?
How can I see all tables in sql?
What are tuples in sql?
Enlist the characteristics of pl/sql?
Do stored procedures prevent sql injection?
What is left join in sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
Is sqlite free?
What is the sql case statement?
Differentiate between sga and pga.
What is sql and how does it work?
how to fetch alternate records from a table? : Sql dba
Can a foreign key be null?
Can a foreign key be a duplicate?
