SELECT TOP 1 Empid FROM (SELECT DISTINCT TOP 6 Empid FROM Employees

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

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

Answer Posted / senthilkumar

SELECT TOP 1 Empid
FROM (SELECT DISTINCT TOP 6 Empid FROM Employees ORDER
BY Empid desc) a ORDER BY Empid asc

Is This Answer Correct ?

4 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Different types of keys in SQL?

1034

What is trace flag in sql server?

977

How to retrieve error messages using mssql_get_last_message()?

994

What is pivot and unpivot?

978

What is an execution plan? How would you view the execution plan?

1014

What is the difference between a local and a global temporary table?

1056

What is the exact numeric data type in sql?

962

How to delete existing triggers using "drop trigger"?

994

What are the extra roles available in msdb? : sql server security

1078

What is the default order of an order by clause?

946

Difference between DELETE and TRUNCATE?

1004

How to convert a numeric expression from one data type to another?

934

what are the different types of SSRS reports?

146

What is difference between line feed ( ) and carriage return ( )?

855

please differentiate between delete and truncate?

944