需求:查询所有用户发布的最新一条视频信息
表示直接从一个数据库结构数据全部复制到另一个库中的,执行sql查出来的数据不一致
select tab.*
from
(
select
v.id videoId ,
v.user_id userId,
v.video_url videoUrl,
v.price,
v.give_num giveNum,
v.gift_num giftNum,
v.coin_num coinNum,
v.forward_num forwardNum,
v.browse_num browseNum,
v.create_time createTime
from t_user_video v
where type = 0
order by v.create_time desc
)tab
group by tab.userId
数据库1 查询结果:
数据库2查询结果:
但是换成下面的sql后,查询结果又是一致的了,如果有知道原因的大佬,还请不吝赐教。
select
v.id videoId ,
v.user_id userId,
v.video_url videoUrl,
v.price,
v.give_num giveNum,
v.gift_num giftNum,
v.coin_num coinNum,
v.forward_num forwardNum,
v.browse_num browseNum,
v.create_time createTime
from t_user_video v INNER JOIN (select user_id ,MAX(create_time) as max_time from t_user_video where type = 0 group by user_id ) vv
on v.user_id = vv.user_id and v.create_time = vv.max_time