[Gfoss] OT (mica tanto)

strk strk a keybit.net
Lun 8 Nov 2010 18:57:06 CET


On Mon, Nov 08, 2010 at 06:47:04PM +0100, a.furieri a lqt.it wrote:

> SELECT Count(*) FROM AccessLog
> WHERE COL010 LIKE '%firefox%';
> SELECT Count(*) FROM AccessLog
> WHERE COL010 LIKE '%safari%';
> SELECT Count(*) FROM AccessLog
> WHERE COL010 LIKE '%chrome%';
> SELECT Count(*) FROM AccessLog
> WHERE COL010 LIKE '%opera%';
> SELECT Count(*) FROM AccessLog
> WHERE COL010 LIKE '%MSIE 6%';
> SELECT Count(*) FROM AccessLog
> WHERE COL010 LIKE '%MSIE 7%';
> SELECT Count(*) FROM AccessLog
> WHERE COL010 LIKE '%MSIE 8%';

SpatialLite non supporta il Group-By ?

 SELECT COL010, Count(*) FROM AccessLog
 GROUP BY COL010 ORDER BY count;

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html


Maggiori informazioni sulla lista Gfoss