sql排序(根据业务逻辑)
2017-06-27 本文已影响4人
欢乐时光欢乐你我
SELECT
S.id, S.owner, S.sealName, S.type, S.active, S.status,S.createTime,
case S.type when 'LP' then 0 when 'ENTERPRISE' then 1 ELSE 2 END typevalue
FROM SEAL S
WHERE S.owner =2175873680049963008 AND S.status != 'DELETE'
ORDER BY typevalue ASC , S.createTime DESC
SELECT
S.id, S.owner, S.sealName, S.type, S.active, S.status,S.createTime
FROM SEAL S
WHERE S.owner = 2175873680049963008 AND S.status != 'DELETE'
ORDER BY FIELD(S.type ,'PERSONAL','ENTERPRISE','LP') DESC , S.createTime DESC
