How to get limit data for each day

Asked Jan 29 '18 at 07:24

Active Jan 29 '18 at 07:24

Viewed 25 times

For example, I want to fetch some data during a particular time; like this:

SELECT DISTINCT IS_ORIGINAL, IS_RELEASED, WORK_ID, IMG_URL, CREATE_TIME
    FROM TB_WORK WHERE USER_ID=#{userId}
    HAVING CREATE_TIME BETWEEN DATE_ADD(CURDATE(), INTERVAL #{startDays} DAY) AND CURDATE()
    ORDER BY CREATE_TIME

but I want to set a limit num for each day, like 20, how could I do that, thanks advanced.

asked Jan 29 '18 at 07:24

T.qeibo

add `limit 20` at the end – Radim Bača Jan 29 '18 at 07:26
you need to add `limit 20` at the end of the query – Ayaz Ali Shah Jan 29 '18 at 07:26
really? I want to limit every day – T.qeibo Jan 29 '18 at 07:27
what is your "num" ? And by day, do you mean real time or the system time ? – Nexus Jan 29 '18 at 07:28
the given time, like from 2017/12/12 to 2017/12/20 – T.qeibo Jan 29 '18 at 07:30

How to get limit data for each day

0 Answers0