我想实现这样一个功能:
表gaz_file(gaz01,gaz02,gaz03,gaz04...)
以上都是关键字,其中gaz03控制语言别,我想查出gaz03='1'比gaz03='3'多出多少笔资料.谢谢,请注意gaz01,gaz02,gaz04是关键字.
表gaz_file(gaz01,gaz02,gaz03,gaz04...)
以上都是关键字,其中gaz03控制语言别,我想查出gaz03='1'比gaz03='3'多出多少笔资料.谢谢,请注意gaz01,gaz02,gaz04是关键字.
(
select * from gaz_file where gaz03='1'
minus
select * from gaz_file where gaz03='3'
)
(select count(1) A from gaz_file where gaz03='1' union
select count(1) A from gaz_file where gaz03='3' ) T2
select (A.qty-B.qty) qty
from
(select count(1) qty from gaz_file where gaz03='1') A,
(select count(1) qty from gaz_file where gaz03='3') B