ini klo mau buat fungsi sendiri ------------------------------------- SELECT field_x,count(field_x) FROM tablenya GROUP BY field_x HAVING count(field_x)= (SELECT max(count(field_x)) FROM tablenya GROUP BY field_x) ------------------------------------- atau coba liat disini: http://stanford.edu/dept/itss/docs/oracle/10g/olap.101/b10339/x_maxbytes008.htm
tq. boss_ayi wrote: > > > Salam semua... > > mau nanya nih buat master2 oracle. > kalo fungsi Modus(Nilai yang paling sering muncul) di oracle gimana ya? > > > > > __________ NOD32 3988 (20090404) Information __________ > > This message was checked by NOD32 antivirus system. > http://www.eset.com
