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

Do you know what are the restrictions that views have to follow?

1127

Can a table be created inside a trigger?

1012

What is parameterized reports in ssrs ?

161

What is key attribute?

980

Can sql server be linked with other servers like oracle?

1022

Explain database normalization?

1267

What are the five major components of a dbms?

961

What are scalar functions in sql?

1208

Why do we use functions?

956

What is store procedure?

1113

What are audit control procedures?

1034

What is snapshot parameter in ssrs?

155

What is rank function?

1084

Can you tell me about the concept of ER diagrams?

1121

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1059