① 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條。