SELECT TOP 5 column FROM table ORDER BY NEWID()

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

16 Answers
25687 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

Please Help Members By Posting Answers For Below Questions

How many joins in sql server?

931

How do I find my localdb version?

971

Can coalesce return null?

997

What does it mean to be in union?

919

What are the kinds of subquery?

1000

What is a view and what are its advantages?

1097

What is the use of nvl work?

988

What is compound operators?

1033

What is reportserver and reportservertempdb ?

152

How to drop an existing schema in ms sql server?

1080

What is page in sql server?

935

What is normalization? Explain different forms of normalization?

1125

Do you know what is replace and stuff function in sql server?

992

What are functions in the sql server?

1190

What are various ways to enhance the ssrs report?

970