1024programmer Oracle Oracle statistics statement by month

Oracle statistics statement by month

Oracle statistics statement by month
the
–Create table Test
CTEATE TABLE TEST(
ID NUMBER NOT NULL,
MODIFIEDTIME DATE NOT NULL
)
— Statistics by month
SELECT TO_CHAR(T.MODIFIEDTIME,’YYYY-MM’) TIME,COUNT(*) COUNT
FROM TEST T www.2cto.com
–You can add query conditions here WHERE TO_CHAR(T.MODIFIEDTIME,'YYYY') = TO_CHAR(SYSDATE,'YYYY')
GROUP BY TO_CHAR(T.MODIFIEDTIME,'YYYY-MM') –Group by month
ORDER BY TO_CHAR(T.MODIFIEDTIME,’YYYY-MM’) ASC NULLS LAST –sort by month
the
— Note: MODIFIEDTIME is the time field in the table TEST, the time type
–The above code can be run directly in the database
–If there is a quantity field in the table, if you want to count the quantity by day, you can change COUNT(*) to SUM(1) function
the
Author guoxuepeng123

This article is from the internet and does not represent1024programmerPosition, please indicate the source when reprinting:https://www.1024programmer.com/oracle-statistics-statement-by-month/

author: admin

Previous article
Next article

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Us

Contact us

181-3619-1160

Online consultation: QQ交谈

E-mail: [email protected]

Working hours: Monday to Friday, 9:00-17:30, holidays off

Follow wechat
Scan wechat and follow us

Scan wechat and follow us

Follow Weibo
Back to top
首页
微信
电话
搜索