SQL Query: Select Column1,Count of rows (criteria1),Count of rows(criteria2).
I need help with a small sql query. Consider the following table:
TicketNo Rules Audit Result
PR123 some random strings Audited PR123 some random strings Not Audited
PR123 some random strings Audited PR123 some random strings Audited PR123
some random strings Not Audited PR123 some random strings Not Audited
PR123 some random strings Audited
PR999 some random strings Audited PR999 some random strings Audited PR999
some random strings Audited PR999 some random strings Audited PR999 some
random strings Audited
PR111 some random strings Not Audited PR111 some random strings Not
Audited PR111 some random strings Not Audited PR111 some random strings
Not Audited
I need the following result: RESULT FORMAT NEEDED
Ticket Count of Audited Rules Count of NOT-Audited Rules
PR123 4 3
PR999 5 0
PR111 0 4
No comments:
Post a Comment