只要custmer 唯一就可以? 用group by 就可以实现了mysql> SELECT * FROM TEST;
+------+-------+
| cust | otime |
+------+-------+
| A | 1 |
| A | 2 |
| A | 8 |
| B | 0 |
| B | 5 |
| C | 0 |
| C | 5 |
| C | 6 |
| C | 6 |
+------+-------+
9 rows in set (0.00 sec)mysql> CREATE TABLE TEST2 AS
-> SELECT CUST,MAX(OTIME) AS OTIMEA FROM TEST GROUP BY CUST;
Query OK, 3 rows affected (0.07 sec)
Records: 3 Duplicates: 0 Warnings: 0mysql> SELECT * FROM TEST2;
+------+--------+
| CUST | OTIMEA |
+------+--------+
| A | 8 |
| B | 5 |
| C | 6 |
+------+--------+
3 rows in set (0.01 sec)
+------+-------+
| cust | otime |
+------+-------+
| A | 1 |
| A | 2 |
| A | 8 |
| B | 0 |
| B | 5 |
| C | 0 |
| C | 5 |
| C | 6 |
| C | 6 |
+------+-------+
9 rows in set (0.00 sec)mysql> CREATE TABLE TEST2 AS
-> SELECT CUST,MAX(OTIME) AS OTIMEA FROM TEST GROUP BY CUST;
Query OK, 3 rows affected (0.07 sec)
Records: 3 Duplicates: 0 Warnings: 0mysql> SELECT * FROM TEST2;
+------+--------+
| CUST | OTIMEA |
+------+--------+
| A | 8 |
| B | 5 |
| C | 6 |
+------+--------+
3 rows in set (0.01 sec)
解决方案 »
- mysql 想用root登录却变成匿名用户
- postgresql批量插入时的事务问题
- mysql语句优化
- 朋友.请问你:存储过程中锁定表现在还不支持吧?那类似问题有没有好的解决方法呢?
- 【高分求教】mysql出现overhead
- mysql小问题,请高手帮忙解答
- 、绝对优质JAVA版本OA系统技术转让!!!
- XP中如何安装哪个版本的mysql(4.0.23还是4.1.8)
- mysql中如何查出符合另一个表中条件的数据?急
- mysql6.3 data文件夹中没有数据库
- mysql支持"SELECT * INTO newTable FROM oldTable" 语句吗
- 急啊!!!GGJJ们救命啊。。。。
create table test2 as select cust,sum(otime) as otimea from test group by cust吧,我认为!
可否?