17,140
社区成员




--把你的sql语句列出来
select *
from inp_bill_detail
where ordered_by='030302'
and item_name = '头孢克肟片'
and Billing_Date_time
between to_date('2010-09-20','yyyy-mm-dd')
and to_date('2010-10-20','yyyy-mm-dd');
select * from inp_bill_detail
where trim(ordered_by)='030302' and trim(item_name) = '头孢克肟片' and Billing_Date_time between to_date('2010-09-20','YYYY-MM-DD') and to_date('2010-10-20','YYYY-MM-DD')
--写了下,不知道有没有结果:
select * from inp_bill_detail
where ordered_by='030302' and item_name = '头孢克肟片'
and Billing_Date_time between to_date('2010-09-20','YYYY-MM-DD') and to_date('2010-10-20','YYYY-MM-DD');
select * from inp_bill_detail where ordered_by='030302' and item_name = '头孢克肟片' and Billing_Date_time ...
select * from inp_bill_detail
where ordered_by='030302' and item_name = '头孢克肟片' and to_char(Billing_Date_time,'YYYY-MM-DD') between '2010-09-20' and '2010-10-20'