[MySQL]ÇóÒ»¾äSQL

Êý¾Ý½á¹¹´ó¸ÅÊÇÕâÑù:

ÈÕÆÚ      ²¿ÃÅ      ÓªÒµ¶î
09-20    ²¿ÃÅ1    100
09-20    ²¿ÃÅ2    200
09-20    ²¿ÃÅ3    300
09-19    ²¿ÃÅ2    400
09-19    ²¿ÃÅ4    500
¡­¡­

´ó¸ÅÊÇÕâô¸öÑù×Ó¡£ÐèÒª¼ÆËã³öÿÌìÓªÒµ¶î×î¸ßµÄ²¿Ãż°ÆäÓªÒµ¶î¡£ÒÔÇ°ºÃÏóд¹ýÕâÖÖ¶«Î÷£¬²»¹ýºóÀ´ÒòΪ±»SQL SERVERµÄÅÅÃûº¯Êý¹ß»µÁË£¬ÏÖÔÚÍêÈ«²»¼ÇµÃÁË¡£Çë¸÷λָµãÖ¸µãСµÜ£¬²»¾¡¸Ð¼¤

---

SQL code:
select * from yourTable a
where not exists (select 1 from yourTable where ÈÕÆÚ=a.ÈÕÆÚ and ÓªÒµ¶î>a.ÓªÒµ¶î);

---

SQL code:

select ²¿ÃÅ,sum(ÓªÒµ¶î) ×ÜÓªÒµ¶î
from ±íÃû
group by ²¿ÃÅ
order by ×ÜÓªÒµ¶î desc
limit 1;

---

»òÕß

SQL code:
select a.*
from yourTable a inner join (select ÈÕÆÚ,max(ÓªÒµ¶î) as max_ÓªÒµ¶î from yourTable group by ÈÕÆÚ) b
on a.ÈÕÆÚ=b.ÈÕÆÚ and a.ÓªÒµ¶î=b.max_ÓªÒµ¶î

---

SQL code:

mysql> select * f