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
Do you know what are different types of replication in sql server?
What are entities and relationships?
How can we use ConnectorJ JDBC Driver with MS SQL?
How can I track the changes or identify the latest insert-update-delete from a table?
What is sql collation?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
Explain about integration services of Microsoft SQL server?
Explain query editor regions
How to loop through returning rows?
How do I debug a stored procedure in sql server?
What does set rowcount do?
Why do we use trigger?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Explain indexing and what are the advantages of it?
Explain multiserver query