In my sql table, when I select data by using this query,

SELECT * FROM agreement_id, hierarchy_id, customer_no FROM rebate_agreement 
WHERE Customer_no = 'Kap-ST';

While I use the above query it filters the records as below,

I want to filter 1st, hierarchy_id is '*' records & other records will display later. Hence I used the below query for it.

SELECT * FROM agreement_id, hierarchy_id, customer_no 
FROM rebate_agreement 
WHERE Customer_no = 'Kap-ST' 
ORDER BY CASE WHEN hierarchy_id = '*' THEN 1 ELSE 2 END;

Then it displays records as below,

But I want to filter my records below format, (Display hierarchy_id ='*' records first and other records for the normal order)

How I do it?

CodePudding user response：

ORDER BY CASE WHEN hierarchy_id = '*' THEN 1 ELSE 2 END, agreement_id

CodePudding user response：

You can take a look at the FIELD() function