select top 1 * from table_name where id in(select top 5 id from table

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 / guest

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

Answer Posted / guest

select top 1 * from table_name where id in(select top 5 id
from table_name order by desc)

Is This Answer Correct ?

9 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a db view?

951

How can I know what locks are running on which resource?

1002

Can sql server 2016 run on windows 7?

967

What is SQL Azure Firewall?

136

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1137

Explain an automatic checkpoint

1020

What is tempdb database? : SQL Server Architecture

1258

What is database dimension? : sql server analysis services, ssas

1144

You want to implement the many-to-many relationship while designing tables. How would you do it?

1053

What is Replication?

1108

What is meant by indexing?

1091

how to trace the traffic hitting a sql server? : Sql server database administration

1959

What is sqlcmd?

1141

What is normalization and what are the advantages of it?

1033

Can you force a query to use a specific index?

993