I have a column for price. I need to select the price based on another column called status. If status is p then select that price first else select price from other status h. I need to make sure that query selects the price if status is p first when both status P & h are available.I have a column for price. I need to select the