ªð¦^¦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

¦^´_ 1# vean0803i


    ...³o¬O°ÝÃDÁÙ¬O¤À¨É...?
³Â·Ð¿ï¶µ¥Øµo©«

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD