--创建视图
CREATE VIEW v_carInfo
AS
SELECT a.*,series,TYPE,retailprice,tuangouprice
FROM (SELECT carID,
确认=SUM(CASE condition WHEN '未' THEN 0 ELSE 1 END),
未确认=SUM(CASE condition WHEN '未' THEN 1 ELSE 0 END),
成交=SUM(CASE chengjiao WHEN '已' THEN 1 ELSE 0 END)
FROM userInfo
GROUP BY carID) AS a INNER JOIN carInfo
ON a.carID=carInfo.carID--从视图中查询数据
SELECT *
FROM v_carInfo
ORDER BY series
CREATE VIEW v_carInfo
AS
SELECT a.*,series,TYPE,retailprice,tuangouprice
FROM (SELECT carID,
确认=SUM(CASE condition WHEN '未' THEN 0 ELSE 1 END),
未确认=SUM(CASE condition WHEN '未' THEN 1 ELSE 0 END),
成交=SUM(CASE chengjiao WHEN '已' THEN 1 ELSE 0 END)
FROM userInfo
GROUP BY carID) AS a INNER JOIN carInfo
ON a.carID=carInfo.carID--从视图中查询数据
SELECT *
FROM v_carInfo
ORDER BY series
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货