Tuesday, December 10, 2013

SQL to find the number of queries run by a user in Netezza



select QH_CLIIPADDR, date(QH_TEND) END_DATE, QH_DATABASE, QH_USER, count(1) from NZ_QUERY_HISTORY
where QH_DATABASE = 'MEDIA_LTAM_UAT' and QH_USER= 'MCHETL' and QH_TEND >= '12-01-2013'
group by QH_CLIIPADDR,END_DATE, QH_DATABASE, QH_USER

order by 2,1,3,4;

No comments:

Post a Comment