本文介紹了使用 CASE WHEN 按兩列排序的處理方法，對大家解決問題具有一定的參考價值，需要的朋友們下面隨著小編來一起學(xué)習(xí)吧！
問題描述
限時送ChatGPT賬號..
我有一個這樣的查詢:
SELECT
ROW_NUMBER() OVER(ORDER BY USER_FNM, USER_LNM) AS ROW_NUM,
USER_TEL, USER_FAX, USER_MOB
FROM
BAUSER
ORDER BY
CASE
WHEN @cOrderBy = 'USER_FNM_USER_LNM ASC' THEN USER_LNM
END ASC,
CASE
WHEN @cOrderBy = 'USER_FNM_USER_LNM DESC' THEN USER_LNM
END DESC,
CASE
WHEN @cOrderBy IS NULL THEN USER_KEY
END ASC
OFFSET @iStartIndex ROWS
FETCH NEXT @iRowsPerPage ROWS ONLY
我想做的是按兩列排序 - 但這顯示語法錯誤:
What I would like to do is sorting by two columns - but this is showing syntax error:
CASE WHEN @cOrderBy = 'USER_FNM_USER_LNM ASC' THEN USER_LNM, USER_FNM END ASC
知道在這種情況下如何按兩列排序嗎?
Any idea how to sort by two columns in this case?
推薦答案
CASE 是一個返回單個表達式/值的表達式.您需要為每一列編寫一個 CASE 語句:
CASE is an expression that returns a single expression/value. You need to write one CASE statement per column:
ORDER BY
CASE WHEN @cOrderBy = 'USER_FNM_USER_LNM ASC' THEN USER_LNM END ASC,
CASE WHEN @cOrderBy = 'USER_FNM_USER_LNM DESC' THEN USER_LNM END DESC,
CASE WHEN @cOrderBy IS NULL THEN USER_KEY END ASC,
CASE WHEN @cOrderBy = 'USER_FNM_USER_LNM ASC' THEN USER_FNM END ASC,
CASE WHEN @cOrderBy = 'USER_FNM_USER_LNM DESC' THEN USER_FNM END DESC
更新(反映更新的問題)
由于您有 ROW_NUM 列，您可以按此排序:
Since you have ROW_NUM column, you can sort by that:
CASE WHEN @cOrderBy = 'USER_FNM_USER_LNM ASC' THEN ROW_NUM END ASC,
CASE WHEN @cOrderBy = 'USER_FNM_USER_LNM DESC' THEN ROW_NUM END DESC,
CASE WHEN @cOrderBy IS NULL
這篇關(guān)于使用 CASE WHEN 按兩列排序的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！
【網(wǎng)站聲明】本站部分內(nèi)容來源于互聯(lián)網(wǎng),旨在幫助大家更快的解決問題，如果有圖片或者內(nèi)容侵犯了您的權(quán)益，請聯(lián)系我們刪除處理，感謝您的支持！