mysql> use mytest;
Database changed
mysql> select * from table2;
+-------+------+----------+
| t | type | time |
+-------+------+----------+
| 10000 | 0 | 08:43:00 |
| 10000 | 0 | 09:44:00 |
| 10001 | 1 | 09:22:00 |
| 10001 | 1 | 09:23:00 |
| 10001 | 1 | 09:24:00 |
| 10001 | 0 | 10:00:00 |
| 10001 | 0 | 11:00:00 |
+-------+------+----------+
7 rows in set (0.00 sec)怎么样select 的结果是显示type=0 的 每个 t值 时间最大的值。
10000 0 09:44:00
10001 0 11:00:00
Database changed
mysql> select * from table2;
+-------+------+----------+
| t | type | time |
+-------+------+----------+
| 10000 | 0 | 08:43:00 |
| 10000 | 0 | 09:44:00 |
| 10001 | 1 | 09:22:00 |
| 10001 | 1 | 09:23:00 |
| 10001 | 1 | 09:24:00 |
| 10001 | 0 | 10:00:00 |
| 10001 | 0 | 11:00:00 |
+-------+------+----------+
7 rows in set (0.00 sec)怎么样select 的结果是显示type=0 的 每个 t值 时间最大的值。
10000 0 09:44:00
10001 0 11:00:00
解决方案 »
- mysql在命令符下如何用insert语句向数据库录入中文数据?????????
- 语句查询问题
- 求My Sql中的存储过程怎么写?
- C语言 操作MySQL UPDATE有问题,请教。
- 关于MYSQL乱码的问题,想得到的设置都设置了,但还是乱码,还漏了哪里??
- 求救mysql error:the table is full
- mysql 同时建立俩个主键和一个AUTO_INCREMENT
- 这个SQL该如何写?
- 请教SQL语句实现 搜索某段时间内的记录条数?
- mysql 启动不起来??急!!
- 一道笔试题:SQl语句如何实现让用户user可以在任何客户端对test数据库进行操作
- 关于dspace中数据存储
+-------+------+----------+
| t | type | time |
+-------+------+----------+
| 10000 | 0 | 08:43:00 |
| 10000 | 0 | 09:44:00 |
| 10001 | 1 | 09:22:00 |
| 10001 | 1 | 09:23:00 |
| 10001 | 1 | 09:24:00 |
| 10001 | 0 | 10:00:00 |
| 10001 | 0 | 11:00:00 |
+-------+------+----------+
7 rows in set (0.00 sec)mysql> select *
-> from table2 a
-> where type=0
-> and not exists (select 1 from table2 where t=a.t and type=0 and `time`>a.time);
+-------+------+----------+
| t | type | time |
+-------+------+----------+
| 10000 | 0 | 09:44:00 |
| 10001 | 0 | 11:00:00 |
+-------+------+----------+
2 rows in set (0.00 sec)mysql>
(SELECT t r,MAX(time) Y FROM table2 GROUP BY t) a,
(SELECT t r,type b,MAX(time) Y FROM a GROUP BY t,type) b
WHERE a.r=b.r
AND a.y=b.y;