Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153761 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / ruchira
select sal from emp
where sal =
(select sal from
(select distinct sal from emp OrderBy sal desc)
[table alias] where rownum < 4 )
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is enter substitution variable in oracle?
Explain what are clusters?
What is meant by an index?
In which language oracle has been developed?
What do you mean by group by clause?
How to export data with a field delimiter?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
11. Display the client number and name and the client number and name of the person who referred that client.
How can I create database in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to get execution path reports on query statements?
How to set up autotrace for a user account?
How to sort output in descending order in oracle?
How to return top 5 rows in oracle?
Point the difference between translate and replace?
