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

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

Answer Posted / kishor

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

Is This Answer Correct ?

3 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to loop through result set objects using odbc_fetch_row()?

951

What is a field name?

945

What are policy management terms?

967

What is merge?

990

How to drop an existing table?

988

What is index, cluster index and nonclustered index?

973

What are orphan records?

917

Can we use max in where clause?

915

What are the built in functions in sql server?

960

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1019

What are the system database in sql server 2008?

1015

Explain filtered indexes benefits?

990

How to replace the Query Result 'Null Value' with a text ?

1014

Can you explain what are various ways to enhance the ssrs report?

987

What is normalization? Describe its different types.

1086