sqlite 排序 case when

“SELECT * FROM com_TKE_SI_PM_bean_InspectionEntity ORDER BY CASE WHEN Status = 2
  THEN 1
  WHEN Status = 4
  THEN 2
  ELSE 3
  END ASC”;

 

status=2排在第一 status=4排在第二  剩下升序