search

Home  >  Article  >  Database  >  SQL （博客）日志归档

SQL （博客）日志归档

WBOY
WBOYOriginal
2016-06-07 17:43:39911browse

SELECT year(sj), month(sj), count(id) FROM News GROUP BY year(sj), month(sj) ORDER BY year(sj) DESC , month(sj) DESC; 结果如图：

SELECT year(sj), month(sj), count(id)
FROM News
GROUP BY year(sj), month(sj)
ORDER BY year(sj) DESC , month(sj) DESC;

结果如图：

，香港服务器，香港虚拟主机，香港服务器
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article： 基于MS SQLServer的全表搜索Next article： 一个高效的分页存储过程

Related articles

See more