[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()"
technique

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

Chris



More information about the thelist mailing list