python输出mysql查询最大值_mysql多分组某字段最大值获取的sql语句 | 工作 实践 真知 分享 IT python资源,python面试,python教程，python自学，pytho...

/*

有几条device_code会列出来几条记录，确保拿到最大的update_time

*/

select device_code, max(update_time) as time from t_car_record group by device_code order by update_time desc

视图的创建

-- ----------------------------

-- View structure for `view_user_course`

-- ----------------------------

DROP VIEW

IF EXISTS `view_user_course`;

CREATE ALGORITHM = UNDEFINED

DEFINER = `root`@`localhost`

SQL SECURITY DEFINER

VIEW `view_user_course` AS (

SELECT

`uc`.`id` AS `id`,

`u`.`name` AS `username`,

`c`.`name` AS `coursename`

FROM

(

(

`user` `u`

LEFT JOIN `user_course` `uc` ON ((`u`.`id` = `uc`.`userid`))

)

LEFT JOIN `course` `c` ON ((`uc`.`courseid` = `c`.`id`))

)

);