How do I get the newest time value in Android Java SQL in my database? -
i have sql database 2 columns "message" , "datetime". want know when last entry added. want highest datetime value.
what efficient way query database in android/java value?
assuming have sqlite:
if column text or real give newest item:
select * table order date(column) desc limit 1
or
select * table order datetime(column) desc limit 1
or simply
select * table order column desc limit 1
Comments
Post a Comment