语句如下 一.
SELECT top 2 user_Integral_tbl.user_Integral_customers_id,sum( user_Integral_tbl.user_Integral_Numerical) as 总成绩 FROM user_Integral_tbl
where not exists (SELECT top 2 user_Integral_tbl.user_Integral_customers_id FROM user_Integral_tbl GROUP BY user_Integral_tbl.user_Integral_customers_id ORDER BY sum( user_Integral_tbl.user_Integral_Numerical) DESC)
GROUP BY user_Integral_tbl.user_Integral_customers_idORDER BY 总成绩 DESC二.
SELECT top 2 user_Integral_tbl.user_Integral_customers_id,sum( user_Integral_tbl.user_Integral_Numerical) as 总成绩 FROM user_Integral_tbl where user_Integral_tbl.user_Integral_customers_id not in (SELECT top 2 user_Integral_tbl.user_Integral_customers_id FROM user_Integral_tbl GROUP BY user_Integral_tbl.user_Integral_customers_id ORDER BY sum( user_Integral_tbl.user_Integral_Numerical) DESC)GROUP BY user_Integral_tbl.user_Integral_customers_idORDER BY 总成绩 DESC
SELECT top 2 user_Integral_tbl.user_Integral_customers_id,sum( user_Integral_tbl.user_Integral_Numerical) as 总成绩 FROM user_Integral_tbl
where not exists (SELECT top 2 user_Integral_tbl.user_Integral_customers_id FROM user_Integral_tbl GROUP BY user_Integral_tbl.user_Integral_customers_id ORDER BY sum( user_Integral_tbl.user_Integral_Numerical) DESC)
GROUP BY user_Integral_tbl.user_Integral_customers_idORDER BY 总成绩 DESC二.
SELECT top 2 user_Integral_tbl.user_Integral_customers_id,sum( user_Integral_tbl.user_Integral_Numerical) as 总成绩 FROM user_Integral_tbl where user_Integral_tbl.user_Integral_customers_id not in (SELECT top 2 user_Integral_tbl.user_Integral_customers_id FROM user_Integral_tbl GROUP BY user_Integral_tbl.user_Integral_customers_id ORDER BY sum( user_Integral_tbl.user_Integral_Numerical) DESC)GROUP BY user_Integral_tbl.user_Integral_customers_idORDER BY 总成绩 DESC
SELECT top 2 user_Integral_tbl.user_Integral_customers_id,sum( user_Integral_tbl.user_Integral_Numerical) as 总成绩 FROM user_Integral_tbl
GROUP BY user_Integral_tbl.user_Integral_customers_idORDER BY 总成绩 DESC