ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

±í½á¹¹ÈçÏÂ
×Ö¶Î1 ×Ö¶Î2 ×Ö¶Î3
1 aaa bbaaa
2 bbaaa bbaaa
3 ccc bbccc
4 bbccc bbccc
5 ddd bbddd

ÒªÇó½á¹ûÈçÏ£º

2 bbaaa bbaaa
4 bbccc bbccc
5 ddd bbddd

×Ö¶Î3ÏàͬµÄ¼Ç¼ȡ ×Ö¶Î2³¤µÄÄÇÌõ£¡

ллÁË

---

SQL code:
select *
from tb t
where not exists(select 1 from tb where col3=t.col3 and len(col2)>len(t.col2))

---

¾ÍÊÇÂ¥ÉϵÄÁË

---

ÒýÓÃ

SQL code
select *
from tb t
where not exists(select 1 from tb where col3=t.col3 and len(col2)>len(t.col2))

up

---

Õý½â »Ø¸´ÓÐ幾·Ö

---

лл¥Éϼ¸Î» ½áÌù