sql²éѯ²»Öظ´ - MS-SQL Server / ÒÉÄÑÎÊÌâ

regInfo ×¢²á±í
MemberId regDate
10001 2010-5-1
10002 2010-5-2
10003 2010-5-3
10004 2010-5-4
10005 2010-5-5
UserRecord ³äÖµ¼Ç¼±í
MemberId money dates
10001 5.00 2010-5-5
10002 10.00 2010-5-5
10001 15.00 2010-5-6
10003 5.00 2010-5-6
10001 10.00 2010-5-7 
10004 20.00 2010-5-7
²éѯµ±Ô ע²áµÄ»áÔ±³äÖµ10ÔªÒÔÉϵļǼ¡£Ö»±£ÁôµÚÒ»Ìõ³äÖµ½ð¶î´óÓÚ10µÄ¼Ç¼ ÒªÇóÏÔʾ½á¹û
10001 15.00 2010-5-6
10002 10.00 2010-5-5
10004 20.00 2010-5-7  
Õâ¸öÔõôд°¡

---

SQL code:
select t.* from UserRecord t , MemberId n where t.MemberId = n.MemberId and datediff(mm,n.regDate,getdate()) = 0 and t.money > 10 and t.money = (select top 1 money from UserRecord where money > 10 and MemberId = t.MemberId)

---

SQL code:
[del]select b.MemberId,max(A.money),min(dates) as FirstDay as MonthMoney from UserRecord a inner join regInfo b on a.MemberId=b.MemberId
where month(a.dates)=month(getdate()) group by a.MemberId
having max(A.money)>10[/del]

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighte