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

What are the restrictions that views have to follow?

982

What are group functions in query statements in ms sql server?

1024

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1072

What are the main differences between #temp tables and @table variables and which one is preferred?

1091

What are the differences between having and where clause.

979

What is a schema in ms sql server 2005?

986

Do you know what is lock escalation?

1022

What is a cache in ssrs?

138

How to set database to be single_user in ms sql server?

1046

How to create a user to access a database in ms sql server using "create user" statements?

959

What is the command to change the recovery model?

1057

Can multiple columns be used in sql group by clause in ms sql server?

1064

How exceptions can be handled in sql server programming?

1024

Does group by or order by come first?

968

Explain full-text indexing?

1002