SQL查询中将某些符合条件的行置顶

业务需求：评论功能–根据当前登录用户显示当前用户的所有评论且置于结果集的顶部。

//例子
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 `所查询条件` = '当前用户ID' THEN 0 ELSE 1 END