復制代碼 代碼如下:

select count(*) from (select gcmc,gkrq,count(*) from gczbxx_zhao t group by gcmc,gkrq having
count(*)>=1 order by GKRQ)
select * from gczbxx_zhao where viewid in ( select max(viewid) from gczbxx_zhao group by
gcmc ) order by gkrq desc ---還是這個可行

復制代碼 代碼如下:

select brand,count(*) from tab_commbaseinfo group by brand having count(*) =1

復制代碼 代碼如下:

select distinct brand from tab_commbaseinfo