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
25490 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

What is temporal data type?

891

what is blocking? : Sql server database administration

998

Is sql server 2016 free?

900

Explain an automatic checkpoint

938

How connect excel to sql server?

947

Tell me when is the update_statistics command used?

1055

Is sql server a database?

945

What is raid and what are different types of raid levels?

1106

How to count duplicated values in a column in ms sql server?

1031

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

955

How can you check the version of sql server?

1065

How to trouble shoot if unable to connect SQL Server

1958

Why truncate is ddl?

1046

What do you mean by a Composite primary key?

1053

What is bcp? When does it use?

898