如何获得集团价值 [英] How to Get Group Value

问题描述

Hello Friends，



我在表格中有两列（A，B列）。

Hello Friends,

I have a two Column in tables (A, B Column).

A	        B
NOVA210601	AJI0001
NOVA210602	AJI0002
NOVA210591	AJI0003
NOVA210592	AJI0003
NOVA210593	AJI0003
NOVA210594	AJI0003
NOVA210595	AJI0004
NOVA210596	AJI0005
NOVA210597	AJI0006
NOVA210598	AJI0006
NOVA210599	AJI0006
NOVA210600	AJI0006
NOVA210570	AJI0006
NOVA210571	AJI0006
NOVA210572	AJI0006
NOVA210573	AJI0007
NOVA210574	AJI0008
NOVA210575	AJI0008
NOVA210576	AJI0008
NOVA210577	AJI0008
NOVA210578	AJI0008
NOVA210579	AJI0009
NOVA210580	AJI0009
NOVA210581	AJI0010
NOVA210582	AJI0011

基于B列分组我想要结果A栏如下

Based on "B" Column grouping i want the result "A" column as follows

NOVA210601
NOVA210602
NOVA210591
NOVA210595
NOVA210596
NOVA210597
NOVA210573
NOVA210574
NOVA210579
NOVA210581
NOVA210582

如何撰写查询？请指导任何人

How to write the query? pls Guide anyone

推荐答案

这个怎么样...

How about this...

SELECT A FROM
(SELECT A, B, RANK() over (Partition By B order by A ) as RANK FROM table)
RS Where Rank =1

尝试这样的事情..

Try something like this..

select min(ColumnA) from YourTable group by ColumnB

这篇关于如何获得集团价值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！