[thelist] DB "Limit" Command Question

Chris Anderson Chris at activeide.com
Thu Apr 16 16:16:24 CDT 2009

> If you happen to use, say, hmmm, Oracle, there is a handy 'sample'
> clause:
> select * from emp sample( 10 );

That's nice!
In SQL Server we have to resort to the expensive "ORDER BY NEWID()"

(Expensive because it results in the server creating a new GUID for
every row)


More information about the thelist mailing list