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
What is Transparent Data Encryption?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
Why is the need for data conversion transformations?
How to search for a string in all stored procedure in sql server?
Please differentiate between a local and a global temporary table?
Why do we backup Active Directory ?
Can we linked SharePoint to a SQL database?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
How to send a ssrs report from ssis?
What is bit data type? What's the information that can be stored inside a bit column?
What’s the use of custom fields in report?
What functions can a view be used to performed?
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
Explain what are the restrictions while creating batches in sql server?
Can sql server be linked with other servers like oracle?