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)?
- 16 Answers
- 23423 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
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
How many full-text indexes can a table have?
How do triggers work?
Explain what is it unwise to create wide clustered index keys?
What is PROJECTION Operation?
When I run the sql server 2000 setup, it just hangs. What do I do?
what is the main function of a query parameter?
How can we delete a table in sql server?
What protocol does sql server use?
What number sorts of privileges are accessible in sql?
What are locks in sql?
Tell me extended events in sql server 2008?
Explain the difference between primary keys and foreign keys?
What are the different types of columns types constraints in the sql server?
How to get the definition of a view out of the sql server?
Explain the truncate command? : SQL Server Architecture
