Select value based on values from other columns : I have question. I have column for price. I need to select 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. Thanks for help