阅读背景:

sql:根据其他列的值选择值

来源:互联网 

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




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: