select *from emp a where 25=(select count(distinct(eno))from emp b where a.

how to get 25th row in any table in sqlserver can u tell me
syntax

Question Posted / svreddy

Answer Posted / svreddy

select *from emp a where 25=(select count(distinct(eno))from emp b where a.eno>=b.eno

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1518

What is policy based management (pbm)? : sql server database administration

585

How can delete duplicate records in cte in sql server?

524

How can you check the level of fragmentation on a table?

612

How do you clear a log file?

513

Does sql server 2000 full-text search support clustering?

510

Define right outer join in sql server joins?

521

What is public role in sql server?

540

Mention the different authentication modes in sql server.

537

Explain what are various ways to enhance the ssrs report?

572

What is in place upgrade in sql server?

524

How many databases instances are there in sql server 2000?

584

What are pages and extents? : SQL Server Architecture

562

What objects does the fn_my_permissions function reports on? : sql server security

563

What does it mean if @@cursor_row returns a negative number?

575