You are here: Re: oracle: sampling statement « PHP SQL « IT news, forums, messages
Re: oracle: sampling statement

Posted by KrunoG on 09/19/06 07:33

"Andy Hassall" <andy@andyh.co.uk> wrote in message
news:gb2ug29t6cqqg4c5kb2qhbmnjcjtrv58i7@4ax.com...

> You mentioned "1st" which implies ordering, so order in a subquery, and
use
> "rownum <= 10000" in the outer query to get only that many rows.
>
> Or you've also mentioned sampling; Oracle has a "sample" clause that you
can
> use to get a percentage of the data:
>
>
>
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10002.htm#i2065953
>
> --
> Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
> http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool


I've tried this but It's not working
ORDER BY dbms_random.valuerownum <= 10000

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация