怎么统计，某个型号的销量，按销量型号排序

[ugvooje]

怎么统计，某个型号的销量，按销量型号排序
现有 sell 表
列名 id,model型号,title名名称，price,shulian数量，
值 1 222 2222 20 100
值 2 555 5555 32 300
值 3 222 2222 220 120
值 4 111 1111 201 200
值 5 222 2222 20 80

怎么把型号222的销量总量统计出来，其它型号并按销量排序出来
用asp怎么写


谢谢

[郭大侠_]

怎么把型号222的销量总量统计出来:
select sum(shulian) from sell where model='2222'
其它型号并按销量排序出来
select model,sum(shulian) from sell group by model order by sum(shulian)

[hz890]

感觉有这一句就可以了
select model,sum(shulian) as ShuLiang from sell group by model order by ShuLiang

[ugvooje]

放到asp里怎么 写

[ugvooje]

在sql库里可以查询，但是要怎么把查询结果通过asp输出到页面上，谢谢

[gingerkang]

0 技术分，结帖率：0.00%

[ugvooje]

怎么再多输出几个列名，不光是上面shulian,和model,

[Me_zhen]

<%
set rs=server.CreateObject("conn.Recordset")
'怎么把型号222的销量总量统计出来:
slq="select sum(shulian) from sell where model='2222'"
rs.open sql,conn,1,1
rs.close
set conn=noting


set rs=server.CreateObject("conn.Recordset")
'其它型号并按销量排序出来
slq="select model,sum(shulian) from sell group by model order by sum(shulian)"
rs.open sql,conn,1,1

rs.close
set conn=nothing

'让全部输出来
select * from sell 
'然后把，在数据库查出来的数据，放到相应的表里面就行了。
%>