mysql数据库sql学习

mysql学习

group by学习

SELECT
	product,
	SUM( guidance_price ) AS guidancePrice,
	COUNT( enterprise_name ) AS enterpriseNumber,
	sum( order_quantity ) AS orderQuantity,
	sum( order_amount ) AS orderAmount,
	sum( capacity ) AS capacity,
	sum( yield ) AS yield 
FROM
	enterprise_data 
WHERE
	node_id = ‘CM-CAUS‘ 
GROUP BY
	product

  

mysql数据库sql学习

上一篇:访问8.0等高版本数据库报错:Client does not support authentication protocol requested by server; consider upgrading MySQL client(客户端不支持服务器请求的身份验证协议;请考虑升级MySQL客户端)


下一篇:json模块和pickle模块的用法