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


Please Help Members By Posting Answers For Below Questions

Explain trigger classes i.e. Instead of and after trigger?

489


What is sql server replication? : sql server replication

537


How to truncate the log in sql server 2012? : sql server database administration

573


How do I view a procedure in sql server?

539


How to make remote connection in database?

597






What is 3nf normalization?

568


What is the architecture of ms sql reporting service?

528


Give the query of getting last two records from the table in SQL SERVER?

541


What are click through reports?

99


What are triggers in ms sql server?

601


Give a example to search fr a string in all stored procedure in sql server.

532


How to filter records of table in SQL SERVER?

601


What are the advantages of sql azure?

116


Which trace flags are enabled in sql server?

522


Why are views required in the sql server or in any other database?

535