sql搜索

--搜索热门资料
select c_keyword,c_time,c_resultcount from dt_History_Search
where c_no in (select MAX(c_no) from dt_History_Search group by c_keyword) and c_type = 2 order by c_time desc

--历史搜索
select c_keyword,c_time,c_resultcount from dt_History_Search
where c_no in (select MAX(c_no) from dt_History_Search group by c_keyword) and c_username = '211080105' and c_type = 2 order by c_time desc