例句
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");