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
25809 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 microsoft sql server?

979

What is the use of sign function?

1124

Explain about extended stored procedure?

940

Do you know what is replace and stuff function in sql server?

1020

What is the difference between clustered and non-clustered indexes in ms sql server?

1003

To which devices can a backup be created and where should these devices be located? : sql server management studio

1044

What do you know about normalization and de- normalization?

925

explain different levels of normalization? : Sql server database administration

1005

Explain the etl (extraction, transformation, and loading)?

995

what are the three command line utilities and what are their primary functions?

144

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

946

What are filegroups in sql server?

1061

What happens if null values are involved in datetime operations?

975

Explain the steps to use transact-sql cursor?

1063

what is the system function to get current user's user id? : Sql server database administration

1005