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
25229 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

What is a database table?

925

What are the different editions available in sql server 2000?

993

Explain steps of normalization?

940

What is a with(nolock)?

925

What is user-defined function?

913

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2667

What are the different methods available under sqlcommand class to access the data?

1058

how would you store your query in an SSRS report or a Database server?

152

What is the full form of ddl?

865

Describe triggers features and limitations?

926

Is BCNF better than 2NF & 3NF? Why?

1002

What happens if null values are involved in boolean operations?

940

Describe in brief system database.

948

How to create median function?

152

What is usually the first word in a sql query?

1069