我的sql 语句:SELECT v.iId, v.iNo, v.vTitle, l.vTitle AS lesson, h.cDate
FROM user_video_history h
LEFT JOIN biz_video v ON h.iVideoId = v.iId
JOIN biz_lesson l ON v.iLessonId = l.iId
WHERE h.vUserCode = '1000048'
GROUP BY vTitle, cDate DESC
LIMIT 0 , 20
需求,我想提取最新时间的那条,拜谢各位了
FROM user_video_history h
LEFT JOIN biz_video v ON h.iVideoId = v.iId
JOIN biz_lesson l ON v.iLessonId = l.iId
WHERE h.vUserCode = '1000048'
GROUP BY vTitle, cDate DESC
LIMIT 0 , 20
需求,我想提取最新时间的那条,拜谢各位了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货