select id,name from member order by posts desc limit 0,10
select count(*) as ct,a.typeid as cc,b.typename from equip_product a inner join protype b on(a.typeid=b.id) group by a.typeid order by 1 desc 这句是找出对应类别的产品数字由多到少的排序 动动脑子就可以改成你要的结果....
select top 10 * from member order by posts desc
select name from member order by posts desc limit 10
如果要是按posts进行查询的话 你的posts字段应该设置成索引,也就是对posts自动排序了 然后用select name from member order by posts desc limit 10 这样就ok了
select top 10 * from member order by posts desc
select name from member order by posts desc limit 10
select name from member order by posts desc,id desc limit 10
select top 10 * from member order by posts desc这是sqlserver的写法.汗楼上正解
select top 10 * from member order by posts
select count(*) as ct,a.typeid as cc,b.typename from equip_product a inner join protype b on(a.typeid=b.id) group by a.typeid order by 1 desc
这句是找出对应类别的产品数字由多到少的排序
动动脑子就可以改成你要的结果....
你的posts字段应该设置成索引,也就是对posts自动排序了
然后用select name from member order by posts desc limit 10
这样就ok了