Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 179653 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / satesh naidu
select * from emp e1 where &n=(select count(distinct
(e2.sal) from emp e2 where e.sal>e1.sal)
Hai friends try this.u will get nth highest salary.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is an indexing technique?
Explain the difference between HTTP and HTTPS in database?
What stored by the model?
Mention the differences between having and where clause.
Explain full-text indexing?
Explain user defined views?
What is server-level principal?
What is difference between cte and view?
What is key attribute?
What is the use of custom fields in report?
Write SQL queries on Self Join and Inner Join.
In which format does an image save in SQL Server database ?
How the authentication mode can be changed?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
