sql条件判断语句
SELECT *
FROM ISSUEBOND_INFO A, ISSUE_REMARK_INFO B
WHERE (B.REMARKNO 《》 ’08’ AND
B.REMARK_AMT 《 (SELECT SUM(A1.NOTIONAL_AMT)
FROM ISSUEBOND_INFO A1
WHERE A1.ISSUE_DATE 《 A.ISSUE_DATE
AND A1.REMARK_NO = A.REMARK_NO))
OR (B.REMARKNO = ’08’ AND
B.REMARK_AMT 《 (SELECT SUM(A1.NOTIONAL_AMT)
FROM ISSUEBOND_INFO A1
WHERE A1.ISSUE_DATE 《 A.ISSUE_DATE
AND A1.REMARK_NO = A.REMARK_NO));
这两条判断就是一个
SELECT *
FROM ISSUEBOND_INFO A, ISSUE_REMARK_INFO B
WHERE B.REMARK_AMT 《 (SELECT SUM(A1.NOTIONAL_AMT)
FROM ISSUEBOND_INFO A1
WHERE A1.ISSUE_DATE 《 A.ISSUE_DATE
AND A1.REMARK_NO = A.REMARK_NO);
sql insert语句加入条件判断怎么写
---不知道你说的是哪种情况,我理解的有2种,1是对插入源进行过滤,2是对插入的某些值作判断,是某个特定值时转换成另一个值
--情况1:使用Insert Into Select语法实现
--通过拼接结果集作为Select数据源之后可以加Where条件
Insert Into YourTable (id,name,status,remark)
Select id,name,status,remark From (
Select 1 as id,’张三’ as name,’在职’ as status,’没有备注’ as remark Union Select 2,’李四’,’离职’,’’
) as s Where id》2 And id《5--条件
--情况2:给插入值作特殊判断
Insert Into YourTable (id,name,status,remark)
Select id,name,Case When status=’在职’ Then 1 WHen status=’离职’ Then 2 Else 0 End,remark From (
Select 1 as id,’张三’ as name,’在职’ as status,’没有备注’ as remark Union Select 2,’李四’,’离职’,’’
) as s
mysql数据库sql查询语句:多条件判断
1、创建测试表,
create table test_person(id int, RMB int);
2、插入测试数据
insert into test_person values(1,180);
insert into test_person values(2,170);
insert into test_person values(3,290);
insert into test_person values(4,160);
insert into test_person values(5,299);
insert into test_person values(6,266);
insert into test_person values(7,155);
3、查询表中所有记录,select t.* from test_person t,
4、编写sql,汇总每个vip类型的用户数,
select vip_type, count(distinct id)
from (select case when RMB》100 and RMB《200 then ’VIP1’ when RMB》200 then ’VIP2’ end as vip_type, id-sql条件判断语句
from test_person) t
group by vip_type