CODEWITHSUNDEEP
mysqlsqlselectlimit
farzad
farzad

Reputation: 654

mysql query select limit when insert date column less than 10

I need a MYSQL query to select only latest 10 records order by insertDate, but I can't fix limit 10 because maybe some record have had same date and I want all column data in latest 10 distinct insertDate rows.

Upvotes: 0

Views: 373

Answers (1)

jarlh
jarlh

Reputation: 44795

Use a sub-query to find 10'th latest insertDate:

select * from tablename
where insertDate >= (select DISTINCT insertDate from tablename
                     order by insertDate desc limit 9,1)
order by insertDate desc

I'm not sure if you want that DISTINCT in the sub-select or not. (I guess not...)

Upvotes: 1

Related Questions