Get latest row form DB

[Anon]

Theres gotta be some easier way of getting info from the latest row than first getting the max counter and then getting the rest by using the counter?

This doesn´t work but something like this perhapsd ooes, please help???

SELECT rubrik FROM tbl_saljes
WHERE counter=(SELECT MAX(counter)
FROM tbl_saljes)

[[deleted]]

Look at the manual for your database and read about the "having" clause:

SELECT *
FROM table
HAVING counter=max(counter);

[Anon]

Or you just simply :
SELECT field
FROM table WHERE counter=max(counter)

vincent wrote:

Look at the manual for your database and read about the "having" clause:

SELECT *
FROM table
HAVING counter=max(counter);

[[deleted]]

Nope, max(counter) can only be evaluated when all records have been selected, but you can't select a record untill you have evaluated max(counter)....
circular reference... why did you think they came up with "having"? 🙂