how to find nth highest salary
Answer Posted / anuj somvanshi
select salary from emp where rownum=n order by salary desc;
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain trigger classes i.e. Instead of and after trigger?
What is sql server replication? : sql server replication
How to truncate the log in sql server 2012? : sql server database administration
How do I view a procedure in sql server?
How to make remote connection in database?
What is 3nf normalization?
What is the architecture of ms sql reporting service?
Give the query of getting last two records from the table in SQL SERVER?
What are click through reports?
What are triggers in ms sql server?
Give a example to search fr a string in all stored procedure in sql server.
How to filter records of table in SQL SERVER?
What are the advantages of sql azure?
Which trace flags are enabled in sql server?
Why are views required in the sql server or in any other database?