select Random rows in SQL Server

1
7

select top 10 cust_id,cust_name from members order by newid()

Will select top 10 rows from members by random

1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here