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

How to enable tcp/ip protocol on a sql server?

1148

What is repeatable read?

1003

What do I need to start working with sql studio? : sql server management studio

1102

What does the not null constraint do?

1070

Which rendering formats are affected by the pagesize properties?

144

What is transaction server consistency?

1035

How you can get the list of largest tables in a database?

1000

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

1066

What is a system database and what is a user database?

1070

What are built in functions?

991

What are different types of statements that are supported by sql?

1033

What is sql server used for?

1032

How many types of objects are there?

995

What is for xml in sql server?

1050

How to change the name of a database user?

950