CODEWITHSUNDEEP
sqlsql-server-cesql-server-ce-3.5
Meowbits
Meowbits

Reputation: 586

SQL Server CE - Select random rows

How do you select a random rows from a table?

For example, if there are 1000 rows in a table matching the criteria that I want, I want to select just 20 random ones.

Like TOP, but random.

Thanks, and this is for SQL Server CE 3.5!

Upvotes: 1

Views: 772

Answers (2)

Milindu Sanoj Kumarage
Milindu Sanoj Kumarage

Reputation: 2774

How about SELECT * FROM tbl_name ORDER BY RAND() LIMIT 0,20; However if your db is with million rows Both newid() and rand() would perform slow. There is a faster solution .Read this

Upvotes: 2

BluesRockAddict
BluesRockAddict

Reputation: 15683

How about this?

 SELECT TOP(20) * FROM myTable ORDER BY NEWID()

Upvotes: 2

Related Questions