Selecting by latest value

admin

Administrator
Staff member
Hi, I was wondering whether it would be possible to find out the value of a column of the latest insert and then select all the rows which have the same value in that, all in one query.

Unclear what I mean? Well, like this:

1. Find out value of column in latest entry
2. Select all rows with the same value as the latest entry

I know how to do this in two calls, but wouldn't it be possible (and faster) to to do it in one call?

Thanks!
 
Back
Top