如果其他SQL查询问题 [英] if else sql query problem

问题描述

hii

我有一个表，其中的列名称为"wmode"，另一个列为"wvaluemin"和"wvaluemax".
wmode具有介于"和更大"两种值.
现在我想做的是一个选择查询，如果wmode值介于两者之间，则输出应为``介于wvaluemin和wvaluemax之间.否则，如果wmode更大，则输出应为更大，然后wvaluemax"
我如何通过if else语句或以任何方式完成此操作.

hii

i have a table in which a column name is ''wmode'' and another coulumns are ''wvaluemin'' and ''wvaluemax''.
wmode has two types of value ''inbetween'' and ''greater''.
now what i want to do is a select query , if wmode values is inbetween then output should be ''Between wvaluemin & wvaluemax. else if wmode is greater then output should be ''Greater then wvaluemax''
how can i accomplish this by an if else statement or anyhow .

推荐答案

尝试:

Try:

Select case wmode
  when 'inbetween' then 'Between ' +convert(varchar,wvaluemin )+ ' &' +convert(varchar,wvaluemax) 
  else   'Greater then' + convert(varchar,wvaluemax)
from table

这篇关于如果其他SQL查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！