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

Popular posts from this blog

java - Jasper subreport showing only one entry from the JSON data source when embedded in the Title band -

serialization - Convert Any type in scala to Array[Byte] and back -

SonarQube Plugin for Jenkins does not find SonarQube Scanner executable -