以下二条语句有什么区别?
1. select * from table
2. select * from table where column1 LIKE '%%' and column2 LIKE '%%' and (column3 LIKE '%%' or column4 LIKE '%%' or column5 LIKE '%%' or column6 LIKE '%%')
谁能帮帮我吗?
...全文
26124打赏收藏
一个SQL面试题
以下二条语句有什么区别? 1. select * from table 2. select * from table where column1 LIKE '%%' and column2 LIKE '%%' and (column3 LIKE '%%' or column4 LIKE '%%' or column5 LIKE '%%' or column6 LIKE '%%') 谁能帮帮我吗?
create table zhiji(支給年月 char(6), 職員番号 char(10))
insert into zhiji
select '200609','0000000001' union
select '200610','0000000001' union
select '200611','0000000001' union
select '200612','0000000001'
create table duixiang (対象年度 char(4),対象年月 char(6),職員番号 char(10),対象年月日 char(8))
insert into duixiang
select 2005, 200608,'0000000001','19910101' union
select 2006, 200606,'0000000001','19910101' union
select 2006, 200607,'0000000001','19910101' union
select 2006, 200610,'0000000001','19920101' union
select 2006, 200612,'0000000001','19930101' union
insert into duixiang values( 2006,null,'','')
select * from duixiang
select * from duixiang where 対象年度 like'%%' and 対象年月 like'%%' and(職員番号 like '%%' or 対象年月日 like '%%')