ÇóÖú£ºSQL Server²éѯ - MS-SQL Server / ÒÉÄÑÎÊÌâ
Á½¸ö±í£¬Ò»¸ö»áÔ±±í£¬Ò»¸öÏû·Ñ¼Ç¼±í¡£ÐèÒª²éµÄÊÇ×î½üÏû·ÑµÄ»áÔ±£¬È»ºó»áÔ±±íͨ¹ýÏû·Ñʱ¼äµ¹ÐòÅÅÐò¡£ÇóÖú´ó¼ÒÔõô×ö¡£ÎÒ´òËãÏÈ·Ö×飬ͳ¼Æ¿¨»áÔ±µÄ¸öÊý£¬È»ºóÔÚͨ¹ýÏû·Ñ±íÖеÄÏû·Ñʱ¼äÌõ¼þÅÅÐò£¬µ«ÕâÑùÅÅÐòÍêÈ«²»ÐС£ÇóÖú´ó¼Ò¸ÃÈçºÎ½â¾ö£¬Ð»Ð»£¡
¸ø³ö±íµÄ½á¹¹¡¢²âÊÔÊý¾Ý¡¢¼°½á¹û
×î½üµÄ·¶Î§½üµ½ÄÄÀÓÐûÓÐÃ÷È·µÄ·¶Î§
·¶Î§Ö»Êǵ¹Ðò¶øÒÑ¡£
»áÔ±±í£ºMember
Ïû·Ñ¼Ç¼±í£ºCashLog
Ïû·Ñ¼Ç¼ÖÐ×ÔÈ»±£³Ö×ŶàÌõµ¥¸ö»áÔ±ÐÅÏ¢£¬ÐèÒª²éѯ×î½üÏû·ÑÅÅÐòµÄÌõ¼þÏû·Ñʱ¼äTimeÊôÓÚCashLog±í¡£
SQL code:
SELECT a.»áÔ±Ãû, MAX(b.Ïû·Ñʱ¼ä) Ïû·Ñʱ¼ä
from »áÔ±±í a
JOIN Ïû·Ñ¼Ç¼±í b
ON a.»áÔ±ID = b.»áÔ±ID
GROUP BY a.»áÔ±Ãû
ORDER BY Ïû·Ñʱ¼ä DESC
SQL code:
select a.*,b.*
from »áÔ±±í a
left join Ïû·Ñ¼Ç¼±í b on a.»áÔ±ID=b.
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
SQL code:
rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......
Ö´ÐÐÊý¾Ý¿â²Ù×÷ʱ£¬Ö±½ÓÓÃSQL Óï¾äºÃһЩ »¹ÊÇÓô洢¹ý³Ì¸ü¼ÑÄØ£¿
¸÷ÊãÆð¼û
Õâ¸öµÄ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö
¼òµ¥µÄselect ¡¢updateºÍinsertµ±È»sql½â¾öÁË
¸´ÔӵķÅÔÚsql·þÎñ¶ËÓ¦¸ÃºÃµã
Â¥Ö÷Çë²ÎÔÄ
http://msdn.micr ......