select top 1 * from (select top 5 * from employee order by empid)sub order

how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?

Question Posted / vishnu

16 Answers
25833 Views
Accenture, IBM, Marlabs, I also Faced
E-Mail Answers

Answer Posted / vishnu

select top 1 * from (select top 5 * from employee order by
empid)sub order by empid desc

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is isolation level at dead lock?

2156

Explain what are the restrictions while creating batches in sql server?

1079

What are the results of running this script?

937

What are a scheduled jobs or what is a scheduled tasks?

903

Is sql server free?

921

What is the difference between clustered and a non-clustered index?

1033

What is transaction server auto commit?

1069

What are unicode character string data types in ms sql server?

1265

What are transactions in sql?

1069

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

912

Explain the categories of stored procedure?

937

What are horizontal and vertical scaling?

172

What are the differences between char and varchar in ms sql server?

1070

Explain the microsoft sql server delete command? : SQL Server Architecture

1091

How to verify the port number of the sql server?

1169