Hi Everyone,
In Generic Inquiry, is this possible to get the duplicate records count just like below sample SQL query.
SELECT username, email, COUNT(*)
FROM users
GROUP BY username, email
HAVING COUNT(*) > 1Can we get a duplicate records count in Generic Inquiry
Userlevel 7
+10
Hi
You won’t be able to o the “HAVING COUNT(*)>1” part in Generic Inquiries, but if you have the count as one of the columns in the results of your inquiry you can filter at the column level.
I don’t have duplicate e-mail addresses in my Users table so I used another table to try out what you’re asking and built a generic inquiry that shows me the count of invoices by customer.
And the column filter:
Userlevel 7
+19
Thanks a lot,
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.