![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
Veyron16
这个作者很懒,什么都没留下…
展开
-
sql字符串合并拼接
<isNotEmpty prepend=" AND " property="status"><iterate property="status" open=" ( " close=" ) " conjunction=" OR "> A.status LIKE concat(concat('%',#status[]#),'%')</iterate></isNotEmpty>原创 2021-04-28 14:46:54 · 489 阅读 · 0 评论 -
mysql:xml日期格式格式化,字段合并,模糊查询 等号查询
date_format(create_date, ‘%Y-%m-%d %H:%i:%s’) as “createDate”原创 2021-04-28 14:26:18 · 630 阅读 · 0 评论 -
关于表重复数据
//查询重复数据select * from T_BBXY_STUDENTFEES a where (a.CLASSID||a.STUDENTID) in (select CLASSID||STUDENTID from T_BBXY_STUDENTFEES group by CLASSID,STUDENTID having count(*) &gt; 1)//oracle//删除重复数据留...原创 2018-11-03 16:30:56 · 45 阅读 · 0 评论