Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 / ritu saini

SELECT TOP 5 column FROM table
ORDER BY NEWID()

Is This Answer Correct ?    14 Yes 25 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know what are different types of replication in sql server?

1154


What are entities and relationships?

1024


How can we use ConnectorJ JDBC Driver with MS SQL?

1053


How can I track the changes or identify the latest insert-update-delete from a table?

1013


What is sql collation?

1269


How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1248


Explain about integration services of Microsoft SQL server?

1086


Explain query editor regions

1108


How to loop through returning rows?

1089


How do I debug a stored procedure in sql server?

1176


What does set rowcount do?

961


Why do we use trigger?

1025


What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1126


Explain indexing and what are the advantages of it?

1070


Explain multiserver query

1113