//查询businessid字段,数据量大于1 count>1
select businessid,count(*) from picture_library t group by businessid having count(*)>1;
//按时间降序(desc)排列,升序为asc
select t.*,rowid from picture_library t order by t.time desc;
//查询table表中 code字段为0或者4的数据
select t.*,rowid from table where code in(0,4);