oracle数据库mybatis常用语句写法

1、mybatis中对年月日时间进行筛选数据时查询不到数据

select sum(SJL) AS RESULTCOUNT from TJ_SJYDATA where trunc(TJ_DATE) = TO_DATE(#tj_date#,'YYYY/MM/DD')

2、进行分组查询时，如果group by的元素是判断元素就用having，不是得话就使用where

select CQID,sum(SJL) AS RESULTCOUNT from TJ_SJYDATA WHERE CSNAME='台州' group by CQID

3、mybatis对不等于，大于，小于的特殊处理

//不等于   <![CDATA[ <> ]]>
select CQNAME,sum(SJL) AS RESULTCOUNT from TJ_SJYDATA WHERE CSNAME='杭州' group by CQNAME having CQNAME <![CDATA[ <> ]]> '其他' and CQNAME <![CDATA[ <> ]]> '杭州'
//小于  <![CDATA[<]]>
//大于  <![CDATA[>]]>

4、取前十条记录

select ZL,TJ_DATE from (select ZL,TO_CHAR(TJ_DATE, 'MM/DD') TJ_DATE from TJ_ZLDATA order by TJ_DATE) where rownum <![CDATA[<]]> 11 order by TJ_DATE