A SQL statement query problem (query minimum value) (urgent)

donkey_ngacn

That's it, thank you

wgfxman

I feel that I only want to see the result data I want, I do n’t value how the data comes ~

zhangyigo

select a.id as "a.id", a.name as "a.name", c.id as "b.id", c.aid as "b.aid", c.price as "b.price" from a
right join (
select top 1 * from b order by price asc) c
on a.id = c.aid

stanley120

我是杀人狂is the simplest

99429499

我是杀人狂does not work, the price of other groups may also be the minimum value of other groups,mydriveris simple and fast!
top! ! ! ! ! ! ! ! ! ! ! ! ! !

origle

mark!

gotoyin

select *
from a a
inner join b b
on a.id=b.aid
and b.id in
(
select min(b.id) from b
where b.price in
(
select min(price) from b
)
)
;

天魔狂舞

SELECT *
FROM A
INNER JOIN B
ON a.id=b.aid
WHERE b.price=
(SELECT MIN(prics)
FROM B)

cool_mohr

我是杀人狂is optimal, but the join needs to be changed to left join

jak1984

declare @A table(id int,name varchar(50))
declare @B table(id int,AID int,price int)

insert @A select 1,'DEMO'
union all
select 2,'DEMO2'

insert @B select 1,1,30
union all select 2,1,32
union all select 3,1,26

select top 1 A.id, A.name, B.id, B.AID, B.price
from @B B
join @A A on A.id=B.AID
order by price