Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT rnk, td_client_id, datetime, td_title, td_url
- FROM
- (
- SELECT
- ROW_NUMBER() OVER (PARTITION BY td_client_id ORDER BY time DESC) AS rnk,
- td_client_id, TD_TIME_FORMAT(time,'yyyy-MM-dd HH:mm:ss','JST') AS datetime, td_title, td_url
- FROM access_log
- WHERE TD_TIME_RANGE(time,'2017-01-01','2017-01-02','JST')
- ) tmp
- WHERE rnk<=3
- ORDER BY td_client_id, rnk
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement