to boss ayi, sorry, boss, saya bln nemu function/keyword dr oracle utk fungsi modus itu :(, tp mungkin function count bs dpake utk workaroundnya... SQL> select first_name, 2 last_name, job_id 3 from emp; FIRST_NAME LAST_NAME JOB_ID -------------------- ------------------------- ---------- steven king ad_pres lexi de haan hh ad_vp alexander harold it_prog bruce ernest it_prog diana lorentz it_prog kevin rajs sa_man trenna davis sa_rep curtis taylor sa_rep peter grant ad_asst jeniffer whalen st_man michael Higgins st_clerk david golia st_clerk 12 rows selected. SQL> select job_id, 2 count(job_id) 3 from emp 4 group by job_id; JOB_ID COUNT(JOB_ID) ---------- ------------- ad_asst 1 ad_pres 1 ad_vp 1 it_prog 3 sa_man 1 sa_rep 2 st_clerk 2 st_man 1 8 rows selected.
moga2 bs mbantu ya, boss... CMIIW, [L] --- On Tue, 5/12/09, boss_ayi <[email protected]> wrote: From: boss_ayi <[email protected]> Subject: [indo-oracle] Modus To: [email protected] Date: Tuesday, May 12, 2009, 10:39 PM Salam semua... mau nanya nih buat master2 oracle. kalo fungsi Modus(Nilai yang paling sering muncul) di oracle gimana ya? [Non-text portions of this message have been removed]
