Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

Home > Database > Mysql Tutorial > body text

按天去除重复数据,为0则取0,否则取最大的那个值_MySQL

WBOY

Release： 2016-06-01 13:07:08

Original

1040 people have browsed it

测试数据：mysql> select * from t2;+----+--------+---------------------+------------+| id | userid | inputDate           | infoStatus |+----+--------+---------------------+------------+|  1 |      1 | 2014-07-11 00:00:00 |      20013 | |  2 |      1 | 2014-07-11 00:00:00 |          0 | |  3 |      2 | 2014-07-12 00:00:11 |      20015 | |  4 |      2 | 2014-07-12 00:00:22 |      20013 | |  5 |      2 | 2014-07-14 00:00:00 |          0 | |  6 |      2 | 2014-07-15 00:00:00 |      20013 | |  7 |      2 | 2014-07-15 00:00:00 |          0 | |  8 |      2 | 2014-07-16 00:00:00 |          0 | |  9 |      2 | 2014-07-13 00:00:00 |      20013 | | 10 |      2 | 2014-07-13 00:00:00 |          0 | | 11 |      2 | 2014-07-14 00:00:00 |          0 | +----+--------+---------------------+------------+查询sql：select id,userid,date(inputDate) as date,max(infoStatus) as m,min(infoStatus) as i,if(min(infoStatus)=0,0,max(infoStatus)) as max from t2 where infoStatus = 0 or infoStatus <p> </p>

Copy after login

source：php.cn

Previous article：Failover with the MySQL Utilities – Part 1: mysqlrpladmin_MySQL Next article：Mysqladmin -help 命令_MySQL

Statement of this Website

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