¶àʱ²»Óã¬sqlд·¨¶¼ÍüÁË

´ó¼Ò°ïæ¿´ÏÂÏÂÃæµÄsqlÎÄÄÄÀï´íÁË£¬ÎÒÔÚSQL ExplorerÖÐÖ´Ðб¨´í¡£Ð»Ð»
1.select * from tb group by sl
2.select * from tb,(select max(id)'id' from tb group by sl)tb2 where tb.id = tb2.id

---

SQL code:
1¡¢select sl from tb group by sl
select ºóÃæµÄÁÐÐèÒª°üº¬ÔھۺϺ¯Êý»ò GROUP BY ×Ó¾äÖÐ

---

2¡¢
mssql 悦﵀

---

ÎÒÀí½âBeirutµÄÒâ˼ÁË¡£ÓÚÊǺõÎҾͲ»ÖªµÀ¸ÃÔõôдÕâÌõsqlÁË¡£sqlµÄÄ¿µÄÊÇsl×Ö¶ÎÖÐÄÚÈÝÏàͬµÄÊý¾ÝֻѡһÌõ¡£

---

SQL code:

1.select * from tb group by sl


ÕâÀï Èç¹ûgroup by sl ÄÇô select ºóÃæ±ØÐëÒªÓÐ sl,sum(×Ö¶Î) »òsl,count(*)ÕâÑùµÄÓï¾ä
ÒòΪÕâ±íʾ¶Ôsl×ֶεÄÖµ½øÐлã×Ü
SQL code:

2.select * from tb,(select max(id)'id' from tb group by sl)tb2 where tb.id = tb2.id


ÕâÀï Ó¦¸ÃÊÇ °Ñselect max(id)'id' from tb group by sl
¸Ä³É select sl,max(id) as 'id' from tb group by sl

---

ÒýÓÃ

2¡¢
mssql 悦﵀

ÔΣ¬ÎÒÕâÀïͨ²»¹ý¡£¡£¡£

---

ÒýÓÃ

ÒýÓà 2 Â¥ beirut µÄ»Ø¸´:
2¡¢
mssql 悦﵀
ÔΣ¬ÎÒÕâÀïͨ²»¹ý¡£¡£¡£

£¿£¿ÄÇ這樣試驗Ï