Advertisement
TDCustmerSupportJP

Untitled

Aug 7th, 2017
1,190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.37 KB | None | 0 0
  1. SELECT rnk, td_client_id, datetime, td_title, td_url
  2. FROM
  3. (
  4.   SELECT
  5.     ROW_NUMBER() OVER (PARTITION BY td_client_id ORDER BY time DESC) AS rnk,
  6.     td_client_id, TD_TIME_FORMAT(time,'yyyy-MM-dd HH:mm:ss','JST') AS datetime, td_title, td_url
  7.   FROM access_log
  8.   WHERE TD_TIME_RANGE(time,'2017-01-01','2017-01-02','JST')
  9. ) tmp
  10. WHERE rnk<=3
  11. ORDER BY td_client_id, rnk
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement