Skip Navigation LinksHome Page > Forums > KronoDesk Forums > KronoDesk Issues & Questi... > Kronodesk DB structure
Hi, I need to check for entries with duplicate names. Our helpdesk can execute a query for me, but they need to have the working query. In general I need something like this (but I do not have a way to know the DB tables and fields names)
SELECT [NameColumn], COUNT(*) AS dupeCount FROM [Helpdek Tickets] GROUP BY [NameColumn] HAVING COUNT(*) > 1
Can somebody help with the correct names?
Please use something like:
SELECT NAME, COUNT(*) AS DupeCount
GROUP BY NAME
HAVING COUNT(*) > 0