Answer #7 should be select top 1 * from (select top n * from tbl order

How to select nth record from a table?

Question Posted / rathika

Answer Posted / rathika

Answer #7 should be

select top 1 * from (select top n * from tbl order by col1
asc) tbl order by col1 desc

where n = nth number in the list

Is This Answer Correct ?

8 Yes

7 No

Please Help Members By Posting Answers For Below Questions

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

1100

How do you identify a foreign key?

1035

How many types of keys are there?

1039

What is store procedure? How do they work? When do you use?

951

When columns are added to existing tables, what do they initially contain?

1041

What is difference between delete & truncate commands?

1090

Do you know what is sql injection?

1005

What is a rownum?

985

How to find the source of a table in sql server?

1005

What is the difference between ‘having’ clause and a ‘where’ clause?

1045

What is a partition function in sql server?

1146

What is cdc in sql server?

1008

Is foreign key unique?

1006

What are the new features are introduced in sql server 2012 reporting services?

153

Where can you find the error log information? : sql server database administration

1035