最高报价: select p.productid as id,p.productname as pname,max(s.price) as maxprice,s.seller as seller group by p.productid limit 0,20最低报价 select p.productid as id,p.productname as pname,min(s.price) as minprice,s.seller as seller group by p.productid limit 0,20=========================================================================== 两句sql语句能不能写成一句,哪位大虾提示一下
不好意思,sql语句写错了select p.productid as id,p.productname as pname,max(s.price) as maxprice,s.seller as seller from sale as s left join product as p on s.productid=p.productid group by p.productid limit 0,20select p.productid as id,p.productname as pname,min(s.price) as minprice,s.seller as seller from sale as s left join product as p on s.productid=p.productid group by p.productid limit 0,20
两句怎么写成一句.... 这样可以显示最高报价商店名称吗?seller1? select A.productid,A.productname,max(B.price) as maxprice,B.seller as seller1 from product as A INNER JOIN sale as B ON A.productid=B.productid group by A.productid limit 0,20
sql语句这样对吗?
因本人是文员 ,写的帖子不够专业,各位高手见谅!!!有兴趣参与电子商务项目开发者,请发信报名 [email protected] 谢谢!!
帖子修改如下:测试题目:
请用你熟悉的技术独立完成下列测试题目,以
便评估能力:现有如下数据库结构
product 表
----------------------------------------------------------
-------
productid 商品编号 int
productname 商品名称 varchar 50
sale 表
----------------------------------------------------------
----------
saleid 报价记录编号 int
productid 报价商品编号(与product表关联)int
seller 报价商店名称 varchar 50
price 价格 float要求各编写一个web程序,选出 商品编号,名称 ,最
高和最低报价,最高和最低报价商店名称,进行列表,并进行分页(每
页20条 记录)。
select p.productid as id,p.productname as pname,max(s.price) as maxprice,s.seller as seller group by p.productid limit 0,20最低报价
select p.productid as id,p.productname as pname,min(s.price) as minprice,s.seller as seller group by p.productid limit 0,20===========================================================================
两句sql语句能不能写成一句,哪位大虾提示一下
这样可以显示最高报价商店名称吗?seller1?
select A.productid,A.productname,max(B.price) as maxprice,B.seller as seller1 from product as A INNER JOIN sale as B ON A.productid=B.productid group by A.productid limit 0,20