ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

§R°£­«½Æ¸ê®Æ

§R°£­«½Æ¸ê®Æ

delete aaaa a
where a.rowid not in  
(
  select max(b.rowid) from aaaa b
    where a.a = b.a
)


a.a(¥Nªía tableªºÄæ¦ì)


§PÂ_¸ê®Æ­«½Æ
select OIV_NO,count(*) from a02_oinvo2 group by oiv_no
vean0803i

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD