Question

sql查询语句

where后面的查询条件
当 is_ownerless_=‘0’时 查询 lock_status_ ='U'
is_ownerless_=‘1' 时 查询lock_status_ ='U' or 'P'
这个改怎么写啊

Answer 1

这个要写在前边select 和 from 中 用 case when
不要这样写在where条件里
把你详细问题说一遍

追问

表里的字段is_ownerless_=有两个值‘0’和‘1’ lock_status_也只有两个值‘U’和‘P’
我现在需要查询 除 is_ownerless_=‘0’且 lock_status_=‘P’ 以外的数据

追答

select case when is_ownerless_=‘0’ and lock_status_ ='U'  then 某字段 
when   is_ownerless_=‘0’ and lock_status_  in ('U','P') then 某字段 end from 表

类似这样吧

追问

谢谢谢谢！
我直接写成select * from tbihdg20 where 1=1 and stock_type_='31' and ((is_ownerless_ = '0' AND lock_status_ = 'U') or (is_ownerless_ = '1' AND lock_status_ IN ('U','P')))就ok了，纠结了这么半天 哈哈！

Answer 2

：select * from table1 where 范围　：insert into table1(field1,field2) values(value1,value2)delete from table1 where 范围　：update table1 set field1=value1 where 范围　：select * from table1 where field1 like ’%value1%’ 　　排序：select * from table1 order by field1,field2 [desc]　　总数：select count as totalcount from table1　　求和：select sum(field1) as sumvalue from table1　　平均：select avg(field1) as avgvalue from table1　　最大：select max(field1) as maxvalue from table1　　最小：select min(field1) as minvalue from table1[separator
是否可以解决您的问题？