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;
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