select top 1 * from (select top 5 * from employee order by empid)sub order

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

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

Answer Posted / vishnu

select top 1 * from (select top 5 * from employee order by
empid)sub order by empid desc

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to invoke a trigger on demand?

1150

What is collation sensitivity?

1134

Tell me in brief how sql server enhances scalability of the database system?

1040

What is key attribute?

980

What is store procedure?

1113

Why I am getting this error when dropping a database in ms sql server?

1119

What is index, cluster index and nonclustered index?

1046

Do you know what are the ways available in sql server to execute sql statements?

1082

How many columns can we include on clustered index ?

1059

What are clustered and non-clustered index?

1049

What is function of CUBE ?

1076

How to find table changes in sql server?

1174

Explain about temporary stored procedure?

1093

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

1133

What type of Index will get created after executing the above statement?

1144