① sql 在cost表中 我要查询会员的消费排名 这个语句怎么写 money1是消费字段 leag_no字段是会员编号 先谢了
消慧世费排名是要总消费吧，先孙梁聚合再排序啊
select leag_no,sum(money1) as m1 from cost group by leag_no order by m1 desc
如果你只要每个会员的最高一条则碧运消费的话
select * from cost as t where exists(select * from cost where t.leag_no=leag_no
group by leag_no having max(money1)=t.money1)
② mysql查询用户的排名
SELECT
obj.user_id,obj.score,@rownum := @rownum + 1 AS rownum
FROM
(
SELECT
user_id,
score
FROM
`sql_rank`
ORDER BY
score DESC
) AS obj,
(SELECT @rownum := 0) r
执行的陪谈结神腊果如下图游乱滑：
③ SQL如何查询，多个用户多笔投资，计算每个用户投资总量排序，类似于每日排行。
--groupby可以解决
select[user],addtime,sum([money])fromborrowgroupby[user],addtime
--user,money是系歼烂统罩改橘表的物团字段不能直接写
④ 写一个SQL查询,列出每个客户的消费总额
select "客户", sum("消费1", "消费2", "消费3","消费4", "消费5") as "消费总额" from 表名 group by "客户";
这样写试一下，看看是否好用。
⑤ 求一sql语句，按用户消费总金额排列
select ta.nane as 用户名,tb.总消费金额 from book as ta
left join
(
select kind as 客户编号 , sum (xfje) as 总消费金额 from xfjl
group by kind
) as tb
on
ta.id=tb.kind
order by tb.总消费金额 asc
⑥ sql查询用户年终消费排名
数据库没说明白，你那个sum是关键字，用起来特殊，暂时给你起名叫pay_sum，到时候你自己改，以sqlserver为例
selecta.*,row_number()over(orderbya.pay_sumdesc)排名
from
(selectpayer,sum(pay_sum)pay_sumfrom表名whereconvert(varchar(4),日期字段,120)='2013'
groupbypayer)a
改替换的字段自己替换一下
⑦ 求一sql语句，按用户消费总金额排列
select xf.khid, book.name, xf.zxfje from
(select khid,sum(xfje) as zxfje from xfjl group by khid) as xf
inner join book on xf.khid = book.id
order by xf.zxfje desc
⑧ sql 在cost表中 我要查询会员的消费排名 这个语句怎么写 money1是消费字段 leag_no字段是会员编号 先谢了
统计总量：
select leag_no,sum(moneyl) as money
from cost
group by leag_no
order by sum(moneyl) desc
按年统计悉坦谈：
select leag_no,sum(moneyl) as money,year(datime) as year
from cost
group by leag_no,year(datime)
order by sum(moneyl) desc,year(datime)
按信侍月统睁碰计：
select leag_no,sum(moneyl) as money,year(datime) as year,month(datime) as month
from cost
group by leag_no,year(datime),month(datime)
order by sum(moneyl) desc,year(datime) ,month(datime)
⑨ 请教如何用SQL语句实现查出表中某时间段内消费最多的5个人，谢谢大师们！
SELECT top 5 code,SUM(xfje) 消费金额合计
FROM A表 JOIN B表 ON A表.kahao=B表.kahao
where A表.date between 开始日期 and 结束日期 and A表.time between 开始时间 and 结束时间
group by code
order by 消费金额合计 desc
⑩ SQL 列出本月消费最多的10位客户 语句怎么写
select top 10 * from 表 order by 消费 desc按照消费降序排列，也就是由高到低排，然后再找出前10条。