一点不小气,百分求一句SQL写法,在线等,ok马上结 如果只有这两个字段,很简单,group by 加 min就行了,如果多于这两个字段,请参考http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=6420 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select name,min(price) as price from tA group by name 楼上,这样列出的内容name和price是对不上的请问就我举的例子,达到我的效果SQL怎么写呢? select * from ta order by price desc第一行就是最小价格的商品 实际应用中不对我实际还有一些字段,照你的写法这样select xxx,xxx,xx,xxx,name,min(price) as price from shop group by name;列出的结果是不正确的.. select XXX,XXX,XXX,name,(select min(price) from shop a where a.name=b.name)from shop b使用子查詢聚合 lxf_1976(小木) ( ):请参考http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=6420 select * from tablename awhere not exists (select * from tablename b where a.name = b.name and a.price < b.price ) select * form tablenamewhere price in(select min(price) from tablename) 上面错了select * from tablenamewhere price in(select min(price) from tablename group by name)group by name select name,min(price) as prices from tA group by namehaving prices<=all( selcet min(prince) from ta group by name ) mysql数据库中一张表中有100万数据,慢的跟蜗牛似的,牛人指点! mysql command line client 怎样输入中文 SQL统计问题.固定行数变为不固定行数并自动取值的问题 c++调用mysql存储过程问题 #sql_ .MYD文件是什么? 用sqlyog操作mysql总是出错 不小心删除了用户!现在无法进行管理MySQL,求助,如何恢复!! EMS MySql Manager试用到期,重新安装后还是不行,该怎么改?谢谢! 关于mysql的一个问题 MySQL C编程,结果集显示 各位哥哥,帮帮小妹。。。。 书上这个例子这个语句为什么老提示错误?
第一行就是最小价格的商品
我实际还有一些字段,照你的写法这样select xxx,xxx,xx,xxx,name,min(price) as price from shop group by name;列出的结果是不正确的..
from shop b
使用子查詢聚合
请参考
http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=6420
where
not exists
(select * from tablename b
where
a.name = b.name
and
a.price < b.price
)
where price in
(select min(price) from tablename)
select * from tablename
where price in
(select min(price) from tablename group by name)
group by name
from tA
group by name
having prices<=all(
selcet min(prince)
from ta
group by name
)