求助关于decodeSQL可不可以这么写select * from FFF where decode('05780560
来源:学生作业帮 编辑:大师作文网作业帮 分类:综合作业 时间:2024/09/24 04:24:38
求助关于decode
SQL可不可以这么写
select * from FFF where decode('05780560','',1=1,PSCODE = '05780560')
看不懂
我知道单条件的时候,不会这么用,但是现在为了支持多条件查询,所以想用这个东西做一个
1=1 和 pscode=?的一个选择
SQL可不可以这么写
select * from FFF where decode('05780560','',1=1,PSCODE = '05780560')
看不懂
我知道单条件的时候,不会这么用,但是现在为了支持多条件查询,所以想用这个东西做一个
1=1 和 pscode=?的一个选择
一般不是这么用的
select * from FFF where aaa=decode('05780560','',1=1,PSCODE = '05780560')
其中decode()作为一个函数返回一个值
select * from FFF where aaa=decode('05780560','',1=1,PSCODE = '05780560')
其中decode()作为一个函数返回一个值
select * from teacher where s_id in(select s_id from student
英语翻译select * from a order by decode(a.xx,50,1,-1)desc
select * from order where clientNo in (select distinct(clien
英语翻译select top 4 * from shop_books where anclassid = (select
SELECT student_id FROM tuition where student_id in ( SELECT
oracle 子查询:select *,(select account from t_ps_member m where
select * from user_info where user_name in (select user_name
select * into b from a where 11
select * from book where 1=1
SQL 语句 "SELECT * FROM {{table}} WHERE `fleet_end_time`
ms sql :select * from (select *from b) as xxx where 和 select
sql 中关于 like SELECT * FROM Persons WHERE City LIKE '%g'