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

阿苏卡果果

select a.id,A.NAME, B.ID,B.AID,B.PRICE from a,b,(select aid, min(price) as minprice from b group by aid) as c where a.id = b. aid and a.id = c.aid and b.price = c.minprice;

haleihalei

If you don't need to check the corresponding b.id, you can do this
select a.name,min(b.price)
from a,b
where a.id=b.aid
group by a.name

suibao007

select a.aid,a.name,b.bid,b.aid,b.price
from a,b
where a.aid=b.aid and b.price=(select min(b.price) from b);

tmh197888

create table tblA(ID int, name varchar(15))
create table tblB(ID int, AID int, price float)

insert into tblA values(1,'Demo')
insert into tblA values(2,'Demo2')

insert into tblB values(1,1,30)
insert into tblB values(2,1,32)
insert into tblB values(3,1,26)


select tblA.id, tblA.name, tblB.id, tblB.aid, tblB.price
from tblA,tblB
where tblA.id=tblB.aid
and tblB.price = (select min(tblB.price) from tblB)

tmh197888

select distinct *
from a,b
where a.id = (select max(id) from a) and b.id = (select max(id) from b)

-------------------------------------------------- -------------------------------

tocv4bf5d65fd:

Your method is wrong, don't mislead others!

tmh197888

select *
from a inner join b t1 on a.id = t1.id
where not exists (select 1 from b where aid = t1.aid and price <t1.price)

-------------------------------------------------- ----------------------------------
tomichealhenry:

Your method is not feasible either!