Hey there,
Sorry, but it doesn't work, at all! The result is still the same, I wrote before.
The count is wrong. It counts every ticket, which is listed, but it should could only the number of diffrent tickets.
I'd be grateful for your answers!
Hey there,
First of all, thanks for your answers!
But sorry, your suggestions don't run at all. The result is always, that impromptu counts every ticket. The result:
Username Ticket Calculation ("count(Ticket)")
dave ticketx 2
david tickety 2...
Hello there,
I've got this:
Username Ticket counter
dave ticketx 1
dave ticketx 1
david tickety 1
david ticketz 1
and the output should be this:
Username counter
dave 1
david 2
In SQL...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.