Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 184672 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 use of custom fields in report?
how to take backup bcp out for a column in table in sql server?
What is ms sql server reporting services?
Do you know what is normalization of database? What are its benefits?
why would you use sql agent? : Sql server database administration
What do mean by xml datatype?
What is factless fact table? : sql server analysis services, ssas
What is trigger explain with program?
What is implicit mode in sql server?
Explain system scalar functions?
How to create a scrollable cursor with the scroll option?
Does a sql server 2005 select statement require a from?
What is the full meaning of dml?
How is table type constraint applied to a table?
How do you open a cluster administrator?
