ÇósqlÓï¾ä

±íÄÚÈÝÈçÏÂ

vipid vipname  hzlx
t001  ÕÅÈý    fdsf
t002  ÀîËÄ    aaaa
t002  ÀîËÄ    bbbb
t002  ÀîËÄ    cccc


Çósql»òÕß´æ´¢¹ý³ÌµÃµ½ÒÔϽá¹û
vipid  vipname  hzlx
t001    ÕÅÈý    fdsf
t002    ÀîËÄ    aaaa
---    ---    bbbb
---    ---    cccc

---

SQL code:
select
vipid=case when exists(select 1 from tb where vipid=t.vipid and hzlx<t.hzlx) then '' else vipid end,
vipname=case when exists(select 1 from tb where vipid=t.vipid and vipname=t.vipname and hzlx<t.hzlx) then '' else vipname end,
hzlx
from tb t

---

еÄ1Ä꿪ʼ£¬×£´ó¼ÒºÃʽÓ2Á¬3£¬ÐÄÇé4¼¾Èç´º£¬Éú»î5ÑÕ6É«£¬7²ÊçÍ·×£¬Å¼¶û8µãС²Æ£¬·³ÄÕÅ×µ½9ÏöÔÆÍ⣡Çë½ÓÊÜÎÒ10ÐÄ10ÒâµÄ×£¸£¡£Ð´º¿ìÀÖ£¡

---

SQL code:
if not object_id('tb') is null
drop table tb
Go
Create table tb([vipid] nvarchar(4),[vipname] nvarchar(2),[hzlx] nvarchar(4))
Insert tb
select N't001',N'ÕÅÈý',N'fdsf' union all
select N't002',N'ÀîËÄ',N'aaaa' union all
select N't002',N'ÀîËÄ',N'bbbb' union all
select N't002',N'ÀîËÄ',N'cccc'
Go
Select