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

SQL--¬d¸ß¨C¤é³Ì¤j­È¡H

SQL--¬d¸ß¨C¤é³Ì¤j­È¡H

¦³¤@­Ó¨C¤é°Ó«~¸ê®Æªí¡A¨C¤Ñ¦³¤â¾÷»ù¿ú¡A·Q­n¬d¸ß¨C¤é³Ì°ª»ù¿úªº¤â¾÷¡A¬d¸ßµ²ªG¦p¥k¹Ï¡A½Ð°Ý­n«ç»ò¼g©O¡H

¤p§Ì¥uª¾¹D«ü©w¤é´Á»PMAX()¨ç¼Æ¡A¦ý¬O³o¼Ë¥u·|¦³¤@µ§¡A¦pªG­n§ï¦¨¨C¤Ñ¡A¥B¬O¨C¤Ñªº³Ì¤j­È¡A¤S¸Ó¦p¦ó¼g©O¡H

ÁÂÁÂ

¤p§Ì¥Îªº¬OACCESS©Î¬OEXCEL

¸É¹Ï¤j®a¬Ý¤@¤U

attachimg]12298[/attachimg]

M01.gif (17.14 KB)

M01.gif

TOP

¦bexcel¤¤¸Õ¥X¨Ó¤F

select * from (select ¤é´Á,max(»ù¿ú)as ª÷¿ú  from [¤u§@ªí1$] group by ¤é´Á) as db1 left join [¤u§@ªí1$] as db2 on db1.¤é´Á=db2.¤é´Á  AND db1.ª÷¿ú=db2.»ù¿ú ORDER BY db1.¤é´Á

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD