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

Do you know hot add cpu in sql server 2008?

1005

Give the query of getting last two records from the table in SQL SERVER?

1016

What are translations and its use? : sql server analysis services, ssas

1087

Where in ms sql server is ’100’ equal to ‘0’?

1135

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

152

Explain left outer join and right outer join?

1092

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1102

What is auditing in sql server?

969

How to create dbo table in sql server?

1009

State a few properties of relational databases?

1184

What programming language would you use to create embedded functions in ssrs?

191

How can you fetch alternate records from a table?

1017

How to copy the tables, schema and views from one sql server to another?

1109

Is it possible to call a stored procedure within a stored procedure?

1030

Why we need to use secondry database file? though, we can do same work using primary database file also.

7014