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 most common trace flags used with sql server?
What is the beast way to write CTE in SQL Server ?
Define constraints and give an example of their use?
on line cluster can we make if yes tell me the procedure
Explain what is log shipping?
How would you use user_constraints table in DB?
Difference between aggregate functions of sql?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
How to get the definition of a stored procedure back?
What is acid db?
How to list all objects in a given schema?
How the authentication mode can be changed?
What is scrollable cursor?
What is ssl in sql server?
How do I start sql server 2016?