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

your distribution database is full what will u do

2217

What does executeupdate return?

1033

Why variables called the most powerful component of ssis?

1122

How to use user defined functions in expressions?

1151

What is measure group, measure? : sql server analysis services, ssas

1071

Ways to improve the performance of a SQL Azure Database?

125

What is an indexing technique?

981

What is enhanced database mirroring in sql server 2008?

1033

How to verify the port number of the sql server?

1251

Why we need to use secondry database file? though, we can do same work using primary database file also.

7008

What is dknf in normalization form?

1111

Can foreign key be duplicate?

1116

How do you drop an index?

973

What is the purpose of sql profiler in sql server?

1067

Why use “pivot” in sql server?

1176