SELECT TOP 1 * FROM (SELECT TOP N * FROM EMPSAL ORDER BY ID DESC) A ORDER B

how to find nth highest salary

Question Posted / bhanu prakash

Answer Posted / bhanu prakash

SELECT TOP 1 * FROM (SELECT TOP N * FROM EMPSAL ORDER BY ID DESC) A ORDER BY ID

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you tell me about the concept of ER diagrams?

1092

Can two different columns be merged into single column? Show practically?

1070

When you should use a low fill factor?

1000

Where is trigger in sql server?

1056

How many types of keys are there?

1039

Explain how to maintain a fill factor in existing indexes?

1000

What part does database design plays a role in performance of an sql server-based application?

992

Explain what is raid and what are different types of raid levels?

1031

Why would you use sql agent?

1273

How do you create a clustered index?

1061

what are the important architecture components of SSRS?

140

what are the core components of SSRS?

130

What is the default port for SQL Server over a firewall?

1107

What is the main purpose of having conversation group?

903

What is a performance monitor?

980