suppose the table x having a column with name empid set rowcount 25 sel

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

Question Posted / venkat

Answer Posted / venkat

suppose the table x having a column with name empid

set rowcount 25
select * from x where empid not in (select top 24 empid
from x)

Is This Answer Correct ?

1 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is bcnf normalization form?

1065

How to verify a login name with sqlcmd tool?

1136

How to execute multiple stored procedures at one time in sql server?

942

Why does sql studio use a single registered database repository? : sql server management studio

952

What are the types of sql server?

988

Define msdb database?

973

List few advantages of stored procedure.

924

How to select true false based on column value in sql server?

953

Why functions are used in sql server?

896

How do I perform an unattended install of sql server 2000?

1018

What is schemabinding a view?

863

What are the joins in sql server? : sql server database administration

962

How to add more data to the testing table in ms sql server?

1000

How many levels of sp nesting are possible?

958

What do you mean by sql server 2005 express management tools?

1251