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 are secondary xml indexes?
What are the advantages of user defined function?
What are cursors stored procedures and triggers?
what are triggers? : Sql server database administration
Can you explain powershell included in sql server 2008?
What is the cartesian product of the table?
How can you set the threshold at which sql server will generate keysets asynchronously?
When would you use the stored procedures or functions?
What are the grouping functions?
What are subqueries in sql server?
What is tabulation?
Explain filestream storage of sql server 2008?
What are the advantages dts has over bcp?
Why transaction is important?
How to replace the Query Result 'Null Value' with a text ?