PD961A

¦^´_ 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