§â¤®æªº¸ê®Æ¥§¡«á¼g¦b¤@ÓÀx¦s®æ¤¤(ªÑ²¼ªº¤¤é§¡½u)
- ©«¤l
- 1180
- ¥DÃD
- 204
- ºëµØ
- 0
- ¿n¤À
- 1051
- ÂI¦W
- 0
- §@·~¨t²Î
- Mac.OS10.6
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2012-9-19
|
¦^´_ 1# joey0415
GOOGLE¦^ÂÐ
http://www.mobile01.com/topicdetail.php?f=512&t=1611893&last=20372916
1. ¥Î Select MAX(¤é´Á) from STOCK_AAA
´N¥i¥H¨ú±o³Ì«á¤@¤Ñªº¤é´Á¡C
©Ò¥H²Õ¦X°_¨Ó´N¥i¥H±o¨ì
Select * from STOCK_AAA where ¤é´Á=(Select MAX(¤é´Á) from STOCK_AAA)
2.
n¨ú±o«e¤¤Ñªº¤é´Á¶°¦X
Select TOP 5 ¤é´Á from STOCK_AAA where ¤é´Á<= '2007/5/28' ORDER BY ¤é´Á DESC
¥Î³Ì¤pÈ¡A´N¥i¥H¨ú¨ì¤¤Ñ«eªº¨ºÓ¤é´Á
SELECT MIN(¤é´Á) FROM (Select TOP 5 ¤é´Á from STOCK_AAA where ¤é´Á<= '2007/5/28' ORDER BY ¤é´Á DESC)
¦A¨Ó¥Î between + ¥§¡È
³Ì«á¥þ³¡²Õ¦X¦¨¤@Ó SQL
¨ä¹ê¨ì³o»ò½ÆÂø¡A¥Î Storage Procedure ©Î °t¦X VIEW ·|¤ñ¸û²³æ©úÁA |
|
|
|
|
|
|