Multiple在表中的计算

create table myTable (

this

Varchar2(10),

that

Varchar2(10)

);

insert into myTable values ('that'

, 'the other');

insert into myTable values ('confusing', 'the other');

insert into myTable values ('this'

, 'that'

);

insert into myTable values ('this'

, 'that'

);

insert into myTable values ('that'

, 'confusing');

insert into myTable values ('confusing', 'that'

);

insert into myTable values ('confusing', 'confusing');

insert into myTable values ('that'

, 'the other');

insert into myTable values ('this'

, 'that'

);

insert into myTable values ('confusing', 'the other');

select

count(

case when

this = 'that' and

that = 'the other'

then 1

else null end) "Count 1",

count(

case when

this = 'this' and

that = 'that'

then 1

else null end) "Count 2",

count(

case when

this = 'confusing'

then 1

else null end) "Count 3"

from

myTable;

• ·Oracle复合数据类型(3)
• ·Oracle复合数据类型(4)
• ·涉外护理英语听说教程(3学生用书五年制高等职业
• ·Oracle复合数据类型(5)
• ·Oracle9i取得建表和索引
• ·OracleSQL中的RANK
• ·英语教程(预备级教师用书)/教育部五年制高等职
• ·ORACLE里取随机数的方法
• ·关于惟一性、空间和数字等问题
• ·oracle数据库中sql基础