[疑难问题] SqlServer如何去重筛选，生成新表格？ [推广有奖]

6关注
0粉丝

博士生

47%

还不是VIP/贵宾

威望: 0 级
论坛币: 5217 个
通用积分: 7.0196
学术水平: 3 点
热心指数: 4 点
信用等级: 2 点
经验: 24876 点
帖子: 133
精华: 0
在线时间: 320 小时
注册时间: 2018-9-16
最后登录: 2023-3-21

楼主

huapeng66

发表于 2021-9-6 13:40:04 |AI写论文

是否 +2 论坛币

k人参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

请问在下表中，SqlServer如何去重筛选，生成新表格？
规则如下：根据unique_id分组，然后提取sku最大那个。表格如附件所示。

sku	an	pnum	unique_id
1	cn201410518246	CN105522183A	cn201410518246+CN105522183A
2	cn201921882278	CN210974964U	cn201921882278+CN210974964U
3	cn201910000278	CN109377643A	cn201910000278+CN109377643A
4	cn201820801226	CN208228469U	cn201820801226+CN208228469U
5	cn201680071437	CN108449995A	cn201680071437+CN108449995A
6	cn201630169597	CN303815920S	cn201630169597+CN303815920S
7	cn93301155	CN3023396D	cn93301155+CN3023396D
8	cn201910801545	CN110938423A	cn201910801545+CN110938423A
9	cn202010201608	CN111335861A	cn202010201608+CN111335861A
10	cn201210322039	CN102856819A	cn201210322039+CN102856819A
11	cn201630397869	CN303986843S	cn201630397869+CN303986843S
12	cn201710952492	CN107719965A	cn201710952492+CN107719965A
13	cn201921758553	CN211001295U	cn201921758553+CN211001295U
14	cn201822273307	CN209520859U	cn201822273307+CN209520859U
15	cn201811027641	CN109109468A	cn201811027641+CN109109468A
16	cn201230119011	CN302090010S	cn201230119011+CN302090010S
17	cn201910504563	CN110117867A	cn201910504563+CN110117867A
18	cn201920838429	CN210421422U	cn201920838429+CN210421422U
19	cn201811251522	CN109294870A	cn201811251522+CN109294870A
20	cn201910009191	CN109559667A	cn201910009191+CN109559667A
21	cn201810940940	CN108929745A	cn201810940940+CN108929745A
22	cn201420366158	CN203934086U	cn201420366158+CN203934086U
23	cn201721684072	CN207904225U	cn201721684072+CN207904225U
24	cn202010112493	CN111355575A	cn202010112493+CN111355575A
25	cn201721775865	CN207669551U	cn201721775865+CN207669551U
26	cn201630101113	CN303838701S	cn201630101113+CN303838701S
27	cn201720466077	CN206845046U	cn201720466077+CN206845046U
28	cn201630181636	CN303940448S	cn201630181636+CN303940448S
29	cn201620035366	CN205491207U	cn201620035366+CN205491207U
30	cn201721026986	CN207007504U	cn201721026986+CN207007504U
31	cn201520361767	CN204632043U	cn201520361767+CN204632043U
32	cn201520882848	CN205273569U	cn201520882848+CN205273569U
33	cn01245293	CN2494892Y	cn01245293+CN2494892Y
34	cn201930295693	CN305257823S	cn201930295693+CN305257823S
35	cn201711182593	CN107890463A	cn201711182593+CN107890463A
36	cn201410158035	CN105023075A	cn201410158035+CN105023075A
37	cn201420363053	CN203959354U	cn201420363053+CN203959354U
38	cn201010151226	CN101794555A	cn201010151226+CN101794555A
39	cn201520010593	CN204427425U	cn201520010593+CN204427425U
40	cn201810969224	CN109271509A	cn201810969224+CN109271509A
41	cn201310409312	CN103449025A	cn201310409312+CN103449025A
42	cn201230119011	CN302090010S	cn201230119011+CN302090010S
43	cn201910504563	CN110117867A	cn201910504563+CN110117867A
44	cn201920838429	CN210421422U	cn201920838429+CN210421422U
45	cn201811251522	CN109294870A	cn201811251522+CN109294870A
46	cn201910009191	CN109559667A	cn201910009191+CN109559667A
47	cn201810940940	CN108929745A	cn201810940940+CN108929745A
48	cn201420366158	CN203934086U	cn201420366158+CN203934086U
49	cn201721684072	CN207904225U	cn201721684072+CN207904225U
50	cn202010112493	CN111355575A	cn202010112493+CN111355575A
51	cn201721775865	CN207669551U	cn201721775865+CN207669551U
52	cn201821101141	CN208398476U	cn201821101141+CN208398476U
53	cn201921018963	CN210789934U	cn201921018963+CN210789934U
54	cn200720140451	CN201036337Y	cn200720140451+CN201036337Y
55	cn97324795	CN3092136D	cn97324795+CN3092136D
56	cn201830439744	CN304933124S	cn201830439744+CN304933124S
57	cn201130383346	CN301904512S	cn201130383346+CN301904512S
58	cn201721397775	CN207453438U	cn201721397775+CN207453438U
59	cn201921015485	CN210674199U	cn201921015485+CN210674199U
60	cn201320878213	CN203654664U	cn201320878213+CN203654664U
61	cn201330522953	CN302833369S	cn201330522953+CN302833369S
62	cn201821961210	CN209166379U	cn201821961210+CN209166379U
63	cn201830090682	CN304688151S	cn201830090682+CN304688151S
64	cn200720174605	CN201108872Y	cn200720174605+CN201108872Y
65	cn201630470515	CN304094744S	cn201630470515+CN304094744S
66	cn201420499929	CN204044240U	cn201420499929+CN204044240U
67	cn201510235223	CN104836067A	cn201510235223+CN104836067A
68	cn200820006140	CN201170347Y	cn200820006140+CN201170347Y
69	cn201830487847	CN304983970S	cn201830487847+CN304983970S
70	cn201911029559	CN110558365A	cn201911029559+CN110558365A
71	cn201210367435	CN103696414A	cn201210367435+CN103696414A
72	cn200930384348	CN301336913S	cn200930384348+CN301336913S
73	cn201530071195	CN303348481S	cn201530071195+CN303348481S
74	cn201510689832	CN105407136A	cn201510689832+CN105407136A
75	cn201822225467	CN209451257U	cn201822225467+CN209451257U
76	cn201621223357	CN206173325U	cn201621223357+CN206173325U
77	cn201910077251	CN109576403A	cn201910077251+CN109576403A
78	cn201921675779	CN210641361U	cn201921675779+CN210641361U
79	cn201330112111	CN302543917S	cn201330112111+CN302543917S
80	cn201320758138	CN203634546U	cn201320758138+CN203634546U
81	cn201720836896	CN207137941U	cn201720836896+CN207137941U
82	cn201330004591	CN302431484S	cn201330004591+CN302431484S
83	cn201130268480	CN301861054S	cn201130268480+CN301861054S
84	cn201710089382	CN106865160A	cn201710089382+CN106865160A
85	cn201510509062	CN105093245A	cn201510509062+CN105093245A
86	cn201130383346	CN301904512S	cn201130383346+CN301904512S
87	cn201721397775	CN207453438U	cn201721397775+CN207453438U
88	cn201921015485	CN210674199U	cn201921015485+CN210674199U
89	cn201320878213	CN203654664U	cn201320878213+CN203654664U
90	cn201330522953	CN302833369S	cn201330522953+CN302833369S
91	cn201821961210	CN209166379U	cn201821961210+CN209166379U
92	cn201830090682	CN304688151S	cn201830090682+CN304688151S
93	cn200720174605	CN201108872Y	cn200720174605+CN201108872Y
94	cn201630470515	CN304094744S	cn201630470515+CN304094744S
95	cn201420499929	CN204044240U	cn201420499929+CN204044240U
96	cn201510235223	CN104836067A	cn201510235223+CN104836067A
97	cn200820006140	CN201170347Y	cn200820006140+CN201170347Y
98	cn201630556325	CN304172472S	cn201630556325+CN304172472S
99	cn201710073262	CN106996213A	cn201710073262+CN106996213A
100	cn201930678157	CN305770533S	cn201930678157+CN305770533S