業(yè)務(wù)需求:評(píng)論功能--根據(jù)當(dāng)前登錄用戶顯示當(dāng)前用戶的所有評(píng)論且置于結(jié)果集的頂部。
//例子
SELECT
AppId,
du.UserName AS UserName,
CreateTime,
Score,
COMMENT,
Id
FROM
ds_applicationcomment dc,
ds_user du
WHERE
dc.UserId = du.UserId
AND AppId = '1'
ORDER BY
CASE when dc.UserId = 'c09d98b4-fc9d-4fea-869f-90b79ded770c' THEN 0 ELSE 1 END,
CreateTime DESC
//核心SQL
CASE when `所查詢條件` = '當(dāng)前用戶ID' THEN 0 ELSE 1 END