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
25682 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 clustered index

991

What is a select query statement in ms sql server?

1051

What are the new data types are introduced in sql 2000?

890

Do you know what is bit data type and whats the information that can be stored inside a bit column?

944

How is a full-text index updated?

936

How to compare the top two records using sql?

1330

Where is localdb stored?

924

Can an entity have two primary keys?

966

How can I check if a view exists in a sql server database?

1018

Explain the phases a transaction has to undergo?

1033

Define right outer join?

963

What are the steps you must follow to hide sql server instances?

961

Other than truncate statement, which other command can by-pass the trigger on the tables?

1112

What is checkpoint in sql server?

1108

How do I view a stored procedure in sql server?

971