Answered
Last n records
Yes – I’m working on a Sunday.
Okay, here’s the deal: I want to retrieve the last n (call it 5) records (non-sequential) from a table. I can easily do this by getting my query to sort desc, and then using maxrows so that it gives me the last 5 – but:
1) I want the last 5 to be in order – for example, I don’t want 10, 9, 8, 7, 6, - which is what the example above gives me, I want 6, 7, 8, 9, 10.
2) The table will have thousands, if not 10s of thousands of records, to select just the row_id desc, will be a huge task. Don’t want the server to work that hard – it’s got other things to do.
My idea is as follows – using the select max(row_id) is easy, it gives me the last record – can't I just do something that will step back n number times from my max query and give me the last n records?
PS: MX8, MySql 5
Okay, here’s the deal: I want to retrieve the last n (call it 5) records (non-sequential) from a table. I can easily do this by getting my query to sort desc, and then using maxrows so that it gives me the last 5 – but:
1) I want the last 5 to be in order – for example, I don’t want 10, 9, 8, 7, 6, - which is what the example above gives me, I want 6, 7, 8, 9, 10.
2) The table will have thousands, if not 10s of thousands of records, to select just the row_id desc, will be a huge task. Don’t want the server to work that hard – it’s got other things to do.
My idea is as follows – using the select max(row_id) is easy, it gives me the last record – can't I just do something that will step back n number times from my max query and give me the last n records?
PS: MX8, MySql 5
AdChoices