select a.id,a.name from dept a where 1= (select COUNT(b.id) from dept b w

How to select nth record from a table?

Question Posted / andy

Answer Posted / andy

select a.id,a.name from dept a
where
1= (select COUNT(b.id) from dept b where b.id>a.id)

Is This Answer Correct ?

4 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is a view in sql?

974

What is user-defined multi-statement table-valued function?

1058

What are indexes in sql?

1279

what is normalization? : Sql server database administration

1095

What is the purpose of a table?

959

What are system databases into sql server (2005/2008)?

999

Can you explain different types of joins?

934

Explain trigger classes i.e. Instead of and after trigger?

877

Tell me something about security and sql azure?

114

Where the sql logs gets stored?

984

Do you know what is openxml in sql server?

1068

Explain SSRS Architecture?

195

What is an example of a foreign key?

973

What are different types of raid levels?

1166

Detail about the hardware which is supported by SQL server?

1063