select count(distinct(country)) from customers;
semoga membantu
M. Iqbal Raliby
Production Application Analyst
Upstream Information Services
ExxonMobil Indonesia
Togar Leo Tampubolon <[EMAIL PROTECTED]> on 10/11/2001 02:20:43 PM
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
cc: (bcc: M Iqbal Raliby/C/Indonesia/Mobil-Notes)
Subject: [GUNADARMA] SQL Statement
Mohon bantuannya! Gimana command sql untuk mencari jumlah recor dari query
yang telah DISTINCT.
Contoh:
SELECT DISTINCT country From customers; terus saya ingin tahu jumlah
recordnya, sql statementnya gimana yah?
Thanks
LEO
* Gunadarma Mailing List -----------------------------------------------
* Archives : http://milis-archives.gunadarma.ac.id
* Langganan : Kirim Email kosong ke [EMAIL PROTECTED]
* Berhenti : Kirim Email kosong ke [EMAIL PROTECTED]
* Administrator: [EMAIL PROTECTED]
* Gunadarma Mailing List -----------------------------------------------
* Archives : http://milis-archives.gunadarma.ac.id
* Langganan : Kirim Email kosong ke [EMAIL PROTECTED]
* Berhenti : Kirim Email kosong ke [EMAIL PROTECTED]
* Administrator: [EMAIL PROTECTED]
