ÇóÖú£º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.
Ïà¹ØÎÊ´ð£º
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......