我有一个惯例,要求将job_id和department_id展示给各部门10,20,50,50并按具体顺序订购为10,50,20select job_id,department_idINTERSECTfrom employeesORDERBY 2,CASE department_id WHEN 10 then 1
我有一个查询,我在DISTINCT ON中使用CASE语句,如下所示: SELECT
DISTINCT ON(COALESCE(users.cuid,events.uid),CASEWHEN events.props->>'prop' IS NULL THEN '$none' WHEN events.props->>'prop' = '' THEN '$none