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)?

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

Can we use having clause without group by?

556


What the difference between UNION and UNIONALL?

576


Explain the properties of sub-query in sql server?

516


What is instead of trigger sql server?

504


What is unique key constraint?

636






What is a hint?

583


how to define testing of network layers? : Sql server database administration

497


What happens if the update subquery returns no rows in ms sql server?

594


Can a rule be bound to any column of any data type?

574


Where views are stored in sql server?

564


OPTIMIZATION OF SP,CURSOR,TRIGGERS

2214


tell me the disaster recovery plan

2031


What are the rendering extensions of ssrs?

105


How can you tell if a database object is invalid?

619


what kind of lan types do you know? : Sql server database administration

521