chilema2的专栏

背景：一个秒杀活动对应多个活动场次，需要通过sql语句查询出最接近当前时间的活动场次 SELECT a.id activityId, a. NAME activityName, s.validity_start_time activityStartTime, s.validity_end_time activityEndTime FROM activity a, activity_session s, activity_rel_session ars WHERE a.id = ars.