Shulou(Shulou.com)06/01 Report--

Requirements: Get the first 30 days of data for each live_id.

Note!! This is very inefficient. Don't run online. Be careful of the frying pan.

Method 1:

SELECT a.* FROM user_live a

LEFT JOIN user_live b ON a.live_id=b.live_id AND a.create_time a.create_time ) ORDER BY a.live_id,a.create_time

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.