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
25668 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

Explain how to send email from sql database?

1026

In what version of sql server were synonyms released?

927

What are the differences between clustered and non-clustered index?

1004

What is a database table?

951

Is sql server is free?

952

In what sequence sql statement is processed?

995

How to update a field in SQL after ALTERING a row?

1218

Where to find ntwdblib.dll version 2000.80.194.0?

946

Tell me what are cursors and when they are useful?

934

Do you have any idea about the tcl commands?

947

What is the most common trace flags used with sql server?

1026

What are trace files?

936

What is the Main Difference between ACCESS and SQL SERVER?

1115

What are the types of table?

960

What is the full meaning of dml?

939