一个SQL语句查询问题（查询最小值）（急）

donkey_ngacn

搞定了，谢谢

wgfxman

感觉搂主仅仅为了看到想要的结果数据，并不看重数据怎么来的~

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

我是杀人狂 最简单

99429499

我是杀人狂 的是不行的，别的组的价格也可能是其他组的最小值，mydriver的简单又快速!
顶！！！！！！！！！！！！！！

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

我是杀人狂是最优的，只是join需要改为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