SELECT DISTINCT kode, nama, qty
INTO namatablebaru
FROM namatablelama
kalau buat cari data mana aja yg double:
SELECT kode
FROM namatable
GROUP BY kode
HAVING COUNT(kode) > 1
best regards
[wwn]
On 1/4/06, Andhi Y <[EMAIL PROTECTED]> wrote:
Teman2,
Saya punya tabel,
Kode Nama Qty
A1 AAAAA 10
A1 AAAAA 10
B1 BBBBB 10
B1 BBBBB 10
C1 CCCCC 5
C1 CCCCC 5
Saya ingin hapus data yang double itu gimana caranya ya? Kalo pake syntax SQL bisa gak? Sehingga data yg saya inginkan seperti ini:
Kode Nama Qty
A1 AAAAA 10
B1 BBBBB 10
C1 CCCCC 5
Thx.
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
