获取数据库最后一条数据

例句

select * from source_data order by time_long desc limit 0,1;

解释：
select * ：所有
from source_data ：从表名为source_data
order by time_long desc ：以time_long进行降序排序
limit 0,1：从第0行开始，去1组数据

代码写法

execSQL 写法

mNightModeHelp.getReadableDatabase().execSQL("select * from " + NightModeDataBase.SourceData.TABLE_NAME + " order by "+NightModeDataBase.SourceData.TIME_LONG +" desc limit 0,1");

query 写法

mNightModeHelp.getReadableDatabase().query(NightModeDataBase.SourceData.TABLE_NAME, null, null, null, null, null, NightModeDataBase.SourceData.TIME_LONG + " desc", "0,1");