mysql - 订单周数和相应。 mysql 中从 51 开始到第 12 周结束的数据

Question

我收到此查询，该查询按周数显示雪深。除了每周、1,2 3 等之外，表中没有其他日期注册。

SELECT 
  res_id,
  wk,
  ROUND(templo, 0) AS templo,
  ROUND(temphi, 0) AS temphi,
  ROUND(snow_valley, 0) AS snow_valley,
  ROUND(snow_mountain, 0) AS snow_mountain 
FROM
  sv_cond_vw_wk 
GROUP BY res_id,
  wk 
HAVING (res_id = 6) 
  AND (wk = 51 
    OR wk = 52 
    OR wk = 52 
    OR wk < 13)

它在第 12 周之后输出第 51 周和第 52 周，但我希望在第 1 周之前输出:51,52,1,2,3,4

Answer 1

您可以在 ORDER BY 子句中使用 FIELD(wk,52,51) DESC ，这样 wk => 51 将首先出现，然后是 wk => 52，然后是其余的那些

SELECT 
  res_id,
  wk,
  ROUND(templo, 0) AS templo,
  ROUND(temphi, 0) AS temphi,
  ROUND(snow_valley, 0) AS snow_valley,
  ROUND(snow_mountain, 0) AS snow_mountain 
FROM
  sv_cond_vw_wk 
GROUP BY res_id,
  wk 
HAVING (res_id = 6) 
  AND (wk = 51 
    OR wk = 52  
    OR wk < 13)
ORDER BY FIELD(wk,52,51) DESC , wk