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
26255 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 do you understand by sql server agent?

1026

What does Master database contains?

1180

Explain the use of containers in ssis and also their types?

1018

what's new in sql server 2016?

1003

Tell about MOM Tool(Microsoft Operator Manager)?

1959

Can I work with several databases simultaneously? : sql server management studio

1029

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1057

What is global temp table?

1045

How many replicas are maintained for each SQL Azure database?

144

Do you know what is a linked server in sql server?

1068

Define left outer join in sql server joins?

1010

How to create an inline table-valued function?

1022

How can I change procedure name in sql server?

1113

What are filegroups in sql server?

1098

What stored by the msdb? : sql server database administration

1052