how to find nth highest salary

Answer Posted / rabi

SELECT A.SAL
FROM TABLE A WHERE &N=(SELECT COUNT(DISTINCT(B.SAL))
WHERE A.SAL<=B.SAL);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Transparent Data Encryption?

654


Explain nested stored procedure. Syntax and an example for create nested stored procedure?

610


Why is the need for data conversion transformations?

587


How to search for a string in all stored procedure in sql server?

627


Please differentiate between a local and a global temporary table?

651






Why do we backup Active Directory ?

704


Can we linked SharePoint to a SQL database?

667


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1872


How to send a ssrs report from ssis?

143


What is bit data type? What's the information that can be stored inside a bit column?

610


What’s the use of custom fields in report?

648


What functions can a view be used to performed?

719


you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

624


Explain what are the restrictions while creating batches in sql server?

700


Can sql server be linked with other servers like oracle?

608