Hi,
Trying to understand the unexpected behavior with following query -
select mid, path, sz, created FROM (select * from Media ORDER BY created DESC LIMIT 20 SKIP 1)
Scenario:
I’ve 5 records in the db. This query ‘select * from Media ORDER BY created DESC LIMIT 20 SKIP 1’ skips first record and returns 4 records, which I intend to do.
But when I combine it like this ‘select mid, path, created FROM (select * from Media ORDER BY created DESC LIMIT 20 SKIP 1)’ it doesn’t skip the records. I would expect it to get details for only filtered results (4 records) but returns details for 5. Is it a bug or something wrong with the query. The above query is simple version of the complex query.
Please can someone comment on it?
~Ruitu