KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
How can I select rows in reverse order in MySQL? For example, I have a table with 12 rows (fields: id,location), I want to select the 4th row before a row with id = 6. I.e., the wanted row will have id = 'not necessarily 2', but there is a condition - where table.location='some_location'. What should the content of request to MySQL be like? Here is a solution! Some example (I checked drodil's suggestion ): mysql> select * from subscrs where id < 100000 order by id desc limit 4; +-------+--------+-----------+-------+ | uid | subscr | event | id | +-------+--------+-----------+-------+ | 5307 | 5123 | feed_news | 99999 | | 25985 | 5211 | feed_news | 99998 | | 15123 | 130 | feed_news | 99997 | | 28368 | 19497 | feed_news | 99996 | +-------+--------+-----------+-------+ 4 rows in set (0.00 sec)
Tags (comma-separated)
Save Edits
Cancel