select top 1 Sal from(select distinct top 5 Sal from TestEmp order by Sal d

write a query for the fifth highest salary?

Question Posted / bhramar

Answer Posted / bhramar

select top 1 Sal from(select distinct top 5 Sal from TestEmp order by Sal desc) a order by Sal

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Differentiate between delete and truncate table?

1006

What is ase database?

963

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2193

Explain data independence & its types.

986

where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

1977

If the master device is full, how do I make the master database bigger?

912

what is transaction state, buffer management, shadow paging

3380

what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?

2261

Which three commands cause a transaction to end?

1005

How many types of locks are present in a database?

1064

During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

1333

Define stored procedure?

969

What is the use of graph database?

969

Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.

1400

How concurrency problems effect the database?

1097