set rowcount 5 select * from table

how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?

Question Posted / ashim pal

16 Answers
26261 Views
Accenture, IBM, Marlabs, I also Faced
E-Mail Answers

Answer Posted / ashim pal

set rowcount 5

select * from table_name

Is This Answer Correct ?

7 Yes

16 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a scheduled job or what is a scheduled task?

1008

Define left outer join in sql server joins?

1010

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

2052

Explain the functionalities that views support?

1162

How does recursive cte works in sql server?

1059

what is a mixed extent? : Sql server administration

1173

What programming language would you use to create embedded functions in ssrs?

191

What is a unique key constraint?

1086

Are all views updatable ?

1201

What is the use of group by clause?

991

What do you mean by collation recursive stored procedure?

1107

what is the information that can be stored inside a bit column? : Sql server database administration

1010

Can we insert data if clustered index is disabled?

986

What are the triggers in sql?

1168

What is difference between temp table and cte?

1072