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

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

1071

What is model database in sql server?

1046

What are the properties of primary key?

966

Name few endpoints exposed by ssrs 2012?

355

What are the different types of normalization?

1158

What are the different acid properties?

1058

What is oltp (online transaction processing)?

1000

Are null values the same as that of zero or a blank space?

1030

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1669

What do you mean by an execution plan? How would you view it?

909

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

1076

Explain triggers in sql?

940

What is the ‘fillfactor’?

964

What are various aggregate functions that are available?

974

Why use “pivot” in sql server?

1103