Pentiums Posted October 23, 2008 Report Share Posted October 23, 2008 Ir tabula: id|ip|browser|timestamp Gribētos izvadīt visus unikālos browser'us un aiz katra pielikt skaitu klāt, cik no katra browsera ir lapa apmeklēta. Daru tā: SELECT distinct browser FROM counter Bet kā lai to skaitu aiz katra browsera piemet? Link to comment Share on other sites More sharing options...
bubu Posted October 23, 2008 Report Share Posted October 23, 2008 SELECT browser, COUNT(*) FROM counter GROUP BY browser Link to comment Share on other sites More sharing options...
Recommended Posts