在顶部显示并标记一些记录

我的目标DBMS是Oracle和MySQL

 SELECT
  users.*
  , hr_orders.position_label
  , hr_orders.is_boss
  , deps.label AS dep_label        -- preprocessor removes AS when using Oracle
  , users.id IN (?) AS show_on_top -- Oracle doesn't accept this IN thing
 FROM
  -- some joins here
 WHERE
  -- some filters

更新

WHERE
    users.fake = 0
AND (
        users.id IN (?)
    OR
        -- some more detailed filters
    )
ORDER BY
    IF (users.id IN (?), 1, 2), users.label

此show\u on\u top字段需要在以后突出显示顶级记录。

因此,如果我移到where子句中,将只选择显示在顶部的用户,而不选择其余的用户。

将查询一分为二并在代码中组合用户列表在我看来仍然很难看。