ASELECT TOP 1 WITH TIES 汽车型号, SUM(销售数量) FROM 汽车销售表
WHERE 销售时间 BETWEEN '2015/1/1' AND '2015/12/31'
GROUP BY 汽车型号
ORDER BY SUM(销售数量) DESC
BSELECT TOP 1 WITH TIES 汽车型号, SUM(销售数量) FROM 汽车销售表
WHERE 销售时间 BETWEEN '2015/1/1' AND '2015/12/31'
GROUP BY 汽车型号
ORDER BY SUM(销售数量) ASC
CSELECT TOP 1 WITH TIES 汽车型号, SUM(汽车型号) FROM 汽车销售表
WHERE 销售时间 BETWEEN '2015/1/1' AND '2015/12/31'
GROUP BY 汽车型号
ORDER BY SUM(汽车型号) DESC
DSELECT TOP 1 WITH TIES 汽车型号, SUM(汽车型号) FROM 汽车销售表
WHERE 销售时间 BETWEEN '2015/1/1' AND '2015/12/31'
GROUP BY 汽车型号
ORDER BY SUM(汽车型号) ASC