Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 37870 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 an index? : Sql dba
How to call shell script from pl sql procedure?
What are the types of join and explain each?
How do I audit the sql sent to the server?
Does mysql_real_escape_string prevent sql injection?
Can sql function call stored procedure?
How you improve the performance of sql*loader? : aql loader
Is mariadb a nosql database?
What are the two types of exceptions.
Does truncate table reset auto increment?
Why self join is used in sql?
Differentiate between % rowtype and type record.
how can we know the count/number of elements of an array? : Sql dba
What are literals in sql server?
What is example of database?
