Is there a way to get random N rows from SQL server table? I saw this link, but that is not what I want. I want to get different number of rows each time I run the query - for example, 5 rows, 10 rows etc
GSerg wrote the following comment:
select top (cast(rand() * 10 as int)) * from table
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments