Öظ´¼Ç¼ֻÏÔʾһÌõµÄsql²éѯÎÊÌâ¡£

Ò»ÕűíÈçÏ£º

id sortid sname
1 1 ¹¤Òµ
2 2 Å©Òµ
3 1 »¯¹¤Òµ
4 3 ¹¤Òµ
5 3 ·þÎñÒµ

´óÖÂÈçÉÏ£¬idΪ×ÔÔö£¬ sortid ÓÐÖظ´£¬snameÒ²ÓÐÖظ´£¬ÏÖÔÚÊÇÒªÈÃsname×Ö¶ÎÖظ´µÄ¼Ç¼ֻÏÔʾÌõ¼´½á¹ûΪ£º

id sortid sname
1 1 ¹¤Òµ
2 2 Å©Òµ
3 1 »¯¹¤Òµ
5 3 ·þÎñÒµ

±¾È˲ËÄñ»¹ÇëÖ¸½ÌÈçºÎдsqlÓï¾ä¡£

---

SQL code:
select * from id in
(
select id from (select min(id) as id, sname from table group by sname) aa
)

---

select * from tableName where id in (select min(id) from tableName group by sname)

---

select
*
from
tbName t
where
sortid=(select min(sortid) from tbName where id=t.id)

---

SQL code:
select min(sortid) from tbName group by sname