Mysql和Oracle语句区别
来源:互联网 发布:淘宝网小饰品店 编辑:程序博客网 时间:2024/05/17 02:39
Mysql语句:
select substr(a.createtime, 1, 4) as statisticsName from defect1 a;
select substr(a.createtime, 1, 7) as statisticsName from defect1 a;select substr(a.createtime, 1, 10) as statisticsName from defect1 a;
Oracle语句一:
select cn.statisticsID, cn.statisticsName ,cn.record as statisticsName from( select to_char(a.solveTime,'yyyy') as statisticsID, count(a.createTime) as record ,to_char(a.createTime,'yyyy') as statisticsName from defect1 a
where 1=1 group by to_char(a.solveTime,'yyyy') , to_char(a.createTime, 'yyyy')) cn where record > '1 ' order by statisticsID
select cn.statisticsID, cn.statisticsName ,cn.record as statisticsName from
( select to_char(a.solveTime,'yyyy-mm') as statisticsID, count(a.createTime) as record ,to_char(a.createTime,'yyyy-mm') as statisticsName from defect1 a
where 1=1 group by to_char(a.solveTime,'yyyy-mm') , to_char(a.createTime, 'yyyy-mm')) cn where record > '1 ' order by statisticsID
select cn.statisticsID, cn.statisticsName ,cn.record as statisticsName from
( select to_char(a.solveTime,'yyyy-mm-dd') as statisticsID, count(a.createTime) as record ,to_char(a.createTime,'yyyy-mm-dd') as statisticsName from defect1 a
where 1=1 group by to_char(a.solveTime,'yyyy-mm-dd') , to_char(a.createTime, 'yyyy-mm-dd')) cn where record > '1 ' order by statisticsID
select substr(to_char(a.solveTime,'yyyy-mm-dd'),1,4) as statisticsID,
count(a.createTime) as record from defect1 a where 1=1 group by substr(to_char(a.solveTime,'yyyy-mm-dd'),1,4)
Oracle语句二:
select cn.statisticsID,statisticsName ,cn.record as statisticsName from
( select substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 4) as statisticsID, count(to_char(a.createTime,'yyyy-mm-dd')) as record,substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 4) as statisticsName from defect1 a
where 1=1 group by substr(to_char(a.solveTime,'yyyy-mm-dd'),1,4),to_char(a.createTime,'yyyy-mm-dd') ) cn where record > '1 ' order by statisticsID
- Mysql和Oracle语句区别
- Oracle和MySQL在SQL语句方面的区别
- Oracle、MySQL和SqlServe分页查询的语句区别
- Oracle和MySQL在SQL语句方面的区别
- mysql和oracle在sql语句上的一些区别
- Oracle和MySQL在SQL语句方面的区别
- Mysql语句改成Oracle语句的区别
- Oracle 和 MYSQL区别
- mysql和oracle区别
- oracle和MySQL区别
- Mysql和oracle区别
- oracle和MySQL区别
- Oracle和mysql区别
- Oracle和MySQL分页语句
- SqlServer,mysql,oracle 数据处理语句的区别
- Oracle与MySQL的SQL语句区别
- MYSQL和 ORACLE 的区别
- mysql和oracle的区别
- tslib移植总结
- VC++中改变Static Text字体的大小
- android adb shell 命令大全
- cdeditor3.6.5+ckfinder2.0.2+jsp编辑器配置 支持服务器浏览/上传图片、Flash
- textFile 限制 输入 字数 代码
- Mysql和Oracle语句区别
- jdbc 连接Mysql数据库
- windows下c++编写多线程
- 详解Spring的配置文件
- Ubuntu“正在替换 cups 1.4.4 ubuntu6XXX”卡住解决办法
- sql 2005 sa权限提权
- VB选择可以打个多个类型的附件
- SWT/JFace 按键、事件、监听
- microsoft 2007的bug