Ãö©ó¸ê®Æ²Îp»PpºâªºSQL«ü¥O
- ©«¤l
- 79
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 193
- ÂI¦W
- 0
- §@·~¨t²Î
- Winwos 7 64 bits
- ³nÅ骩¥»
- Excel 2003/2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TAIPEI
- µù¥U®É¶¡
- 2010-8-25
- ³Ì«áµn¿ý
- 2019-9-20
|
¥»©«³Ì«á¥Ñ diabo ©ó 2013-1-10 10:22 ½s¿è
¦^´_ 1# ¤p»x
¤£¦Ò¼{®Ä¯àªº¸Ü¡A§Q¥Î¤l¬d¸ß¥i¥H§@¨ì....
PS
1 ±N¸ê®Æ²¾¨ì¡iDB¤u§@ªí¡j
2 §Aªº´ú¸Õ¸ê®Æ¦³ÂI°ÝÃD¡A§Ç¸¹»P½Ð°²¤éÀ³¸Ó³£n¥Ñ¤p¨ì¤j¤~¦X²z...
select tmpTable2.§Ç¸¹2,tmpTable2.½Ð°²¤é2,tmpTable2.©m¦W2, tmpTable.©Ê§O,tmpTable2.¦~ÄÖ2, tmpTable.ì¦],tmpTable2.½Ð°²¼Æ2 from ((select max(§Ç¸¹) as §Ç¸¹2, max(½Ð°²¤é) as ½Ð°²¤é2, ©m¦W as ©m¦W2, max(¦~ÄÖ) as ¦~ÄÖ2, count(*) as ½Ð°²¼Æ2 FROM [DB$A:F] GROUP BY ©m¦W) tmpTable2),((select * From [DB$A:F]) tmpTable) Where tmpTable2.§Ç¸¹2=tmpTable.§Ç¸¹ |
-
1
µû¤À¤H¼Æ
-
-
¤p»x:
À°¤F¤j¦£Åo, §ÚªºSQL¨ä¹ê§ó½ÆÂø,¦ý´N¯Ê¤F§A ...ª÷¿ú + 5
|
diabo
|
|
|
|
|