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

阿苏卡果果

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

如果不需要查对应的b.id的话可以这样
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)

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

to cv4bf5d65fd :

你的方法是错误的，不要误导人家啦！

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)

------------------------------------------------------------------------------------
to michealhenry:

你的方法也不可行哦！