select distinct count(*) AS count, VL_GUESTNAME from? T_VISIT_LOG where CONVERT(varchar(10),VL_CHECKINTIME,120)>'2015-09-30' GROUP BY VL_GUESTNAME Order by count DESC
篩選出最近一年訪客及訪問(wèn)次數(shù)
select? distinct top 6 count(*) AS count, GUESTNAME from? EV_VISIT_LOG where CONVERT(varchar(10),CHECKINTIME,120)>'2015-09-30' GROUP BY GUESTNAME Order by count DESC
列出訪問(wèn)次數(shù)最多的前六名訪客
