在子查询中怎么获取A最小值的B列

[Dision LI]

select 1,最小=(
select  min(A)   FROM (

select 1 as 'A',1 as 'B'
union
select 1 as 'A',2 as 'B'
union
select 2 as 'A',3 as 'B'
union
select 3 as 'A',4 as 'B'
union
select 3 as 'A',4 as 'B'
union
select 4 as 'A',4 as 'B'
union
select 2 as 'A',4 as 'B'
) T
 
)

--from tb 

在子查询中怎么获取A最小值的B列,默认为第一条

得出结果 1 1

[叶子]

select 1, min(A) 
FROM (select 1 as 'A',1 as 'B'
union select 1 as 'A',2 as 'B'
union select 2 as 'A',3 as 'B'
union select 3 as 'A',4 as 'B'
union select 3 as 'A',4 as 'B'
union select 4 as 'A',4 as 'B'
union select 2 as 'A',4 as 'B') T
/*
1           1
*/

[AcHerat]

declare @tb table(a int,b int)
insert into @tb
select 1,1
union
select 1,2
union
select 2,3
union
select 3,4
union
select 3,4
union
select 4,4
union
select 2,4

select *
from @tb t
where not exists (select 1 from @tb where a < t.a or (a = t.a and b < t.b))

/***************

a           b
----------- -----------
1           1

(1 行受影响)

[Dision LI]

我想获取的是min(A)那行的列B的值

[叶子]

;with T as(
select 1 as 'A',1 as 'B'
union select 1 as 'A',2 as 'B'
union select 2 as 'A',3 as 'B'
union select 3 as 'A',4 as 'B'
union select 3 as 'A',4 as 'B'
union select 4 as 'A',4 as 'B'
union select 2 as 'A',4 as 'B') 

select top 1 * from T a
where B=(select min(B) from T where A=a.A)
order by A
 
/*
A           B
----------- -----------
1           1
*/

刚才理解错了，修正一下。

[Dision LI]

谢谢2楼。我看一下先

[gbren]

SELECT TOP 1 A ,
MIN(B) B
FROM ( SELECT 1 AS 'A' ,
1 AS 'B'
UNION
SELECT 1 AS 'A' ,
2 AS 'B'
UNION
SELECT 2 AS 'A' ,
3 AS 'B'
UNION
SELECT 3 AS 'A' ,
4 AS 'B'
UNION
SELECT 3 AS 'A' ,
4 AS 'B'
UNION
SELECT 4 AS 'A' ,
4 AS 'B'
UNION
SELECT 2 AS 'A' ,
4 AS 'B'
) T
GROUP BY A
ORDER BY A