復(fù)制代碼 代碼如下:

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 ---還是這個(gè)可行

復(fù)制代碼 代碼如下:

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

復(fù)制代碼 代碼如下:

select distinct brand from tab_commbaseinfo