lundi 16 mars 2015

Sqlite get max id not working (?)

Im using this:



SELECT *
WHERE id=MAX(id)
FROM history;


But my query is empty. I have also tried this (This one works):



SELECT MAX(id) AS max_id
FROM history;


But obviusly my query only contains the max_id key. What am I doing wrong with the first one?


Aucun commentaire:

Enregistrer un commentaire