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

How does normalization work?

865

What is attribute? : sql server analysis services, ssas

978

What is correlated subquery in sql server?

1016

How to list all stored procedures in the current database using ms sql server?

1054

Explain cross join or cartesian product in sql?

840

What is the contrast between sql and mysql?

1049

Why use view instead of a table?

880

explain databases and sql server databases architecture? : Sql server database administration

909

What is the minimum recommended amount of ram for sql server 2012 enterprise?

887

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

1624

Explain cdc and sql injection?

912

What is BCP? When does it used in sql server 2012?

998

Can we do dml on views?

914

Do you know what is rank function?

1029

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

928