hmm.. frequency ya maksudnya

select <field>,count(<field>)  from <table>
group by <field>
having count(<field>) =
(
 select max(count(<field>)) from <table>
 group by <field>
)

muter muter dikit.. dengan mengorbankan explain plan..:(
moga2 membantu

Regards
Danar Prabandaru

On Tue, May 12, 2009 at 10:39 PM, boss_ayi <[email protected]> wrote:
> Salam semua...
>
> mau nanya nih buat master2 oracle.
> kalo fungsi Modus(Nilai yang paling sering muncul) di oracle gimana ya?
>
>
>

Kirim email ke