Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 182262 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / manshul
select * from employee e, (select salary, rownum rn from
(select distinct salary from employee order by salary desc))
T where T.sal= e.sal and T.rn = 4
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the contrast amongst drop and truncate?
What is the difference between primary key and unique constraints?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What is report subscription?
How to insert and update data into a table with "insert" and "update" statements?
what is raid and what are different types of raid configurations? : Sql server database administration
What are the security related catalog views? : sql server security
What is sql server transaction log file?
what is a traditional network library for sql servers? : Sql server database administration
your distribution database is full what will u do
What is an identity?
Can primary key be a foreign key?
How to trouble shoot if unable to connect SQL Server
What is sql server profiler trace data file?
Does group by or order by come first?
