摘要：
现在我要查：select * from dual where time = to_date('2012-06-18 11:41:41','yyyy-MM-dd hh24:mi:ss');这样是能查询处理的。但是，时间是我从页面得到的值，是省略了时分秒的select * from dual where time = to_date('2012-06-18','yyyy-MM-dd');这样是查不出来的。写法有很多种，例如下面的：方法一：select * from dual where time between to_date( 阅读全文
摘要：
select a.ordercode,count(*) from tb_order_yhd a group by a.ordercode having count(*)>1; 阅读全文