select * from TableName where Model_Number in ('M0001','M0002','M0003')
SELECT * FROM TB ORDER BY CASE WHEN Model_Number in ('M0001','M0002','M0003') THEN 0 ELSE 1 END;
SELECT * FROM TB ORDER BY CASE WHEN Model_Number in ('M0001','M0002','M0003') THEN 0 ELSE 1 END; SELECT * FROM TB ORDER BY DECODE(Model_Number,'M0001',0,'M0002',1,'M0003',2,3);
FROM TB
ORDER BY CASE WHEN Model_Number in ('M0001','M0002','M0003') THEN 0 ELSE 1 END;
FROM TB
ORDER BY CASE WHEN Model_Number in ('M0001','M0002','M0003') THEN 0 ELSE 1 END; SELECT *
FROM TB
ORDER BY DECODE(Model_Number,'M0001',0,'M0002',1,'M0003',2,3);