How to get last record

[rcmz]

Hello

I have a table in a FB database that holds all the invoices of a Client and I would like to get the last invoice of any client.

At this moment I select * from invoices where client = noclient order by date
and then go to Last

Is ther a way to get only the last record so that this process be a lot faster.

TIA
Ramiro

[Plash]

You can use a query like the following:

Code: Select all

select * from invoices where client = noclient
order by date desc
rows 1

[rcmz]

Hi,

thank you for your fast reply

I tried your suggestion but if the client haves 2 or more invoices on the same day it fetches the first in that day and not exactly the last one.

I also have an ID column on that table.

TIA
Ramiro

[Plash]

You should modify your table to have a column of TIMESTAMP type. In this case you can find a record with the largest value in this column.