Answer Posted / cpnagar
SELECT salary FROM (SELECT ROW_NUMBER() OVER (ORDER BY
salary desc) AS RN,*
FROM
emp)temp
WHERE
RN=3
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is the difference between nvl and nvl2?
Tell me when is the update_statistics command used?
What is delete query?
When to use Inner join & when to use subquery?
Please illustrate physical database architecture? : SQL Server Architecture
Can we hide the definition of a stored procedure from a use?
optimization techinques
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Explain trigger and its types?
What do you understand by check constraint in sql server?
Explain datetimeoffset data type in sal server 2008?
Explain full-text query in sql server?
What is checkpoint process in the sql server?
Can two tables share the same primary key?
what is database replication? : Sql server database administration
