mysql hash

Anonymous — Sat, 29 Nov 2014 22:29:23 GMT

Dear all,

I'm trying to realize a new qlikview document based on a mysql script that is not so clear for me

SELECT sum(numPages) AS NUMPAGE, (SELECT count(numpages) from MYTABLE where doctype= 'ORDER' and left(DATE_FORMAT(FROM_UNIXTIME(LEFT(ORDERDATE, LENGTH(ORDERDATE) -3)), '%Y%m%d'),6) = left(DATE_FORMAT(FROM_UNIXTIME(LEFT(tb.ORDERDATE, LENGTH(tb.ORDERDATE) -3)), '%Y%m%d'),6)) AS NUMDOC,

left(DATE_FORMAT(FROM_UNIXTIME(LEFT(ORDERDATE, LENGTH(ORDERDATE) -3)), '%Y%m%d'),6) AS ANNO

from TABLE. documents as TB where (doctype= 'ORDER' )

and not hash is null group by left(DATE_FORMAT(FROM_UNIXTIME(LEFT(ORDERDATE, LENGTH(ORDERDATE) -3)), '%Y%m%d'),6)

I underlined what I don't understand. I think it should group by year and month, but what does it means "..and not hash is null " ?

I hope somebody can put me on the right track

Help please.

Thank in advance

topic mysql hash in QlikView

mysql hash