SELECT entryid, Count(entryid) AS ecount
FROM filelocation
GROUP BY entryid
HAVING (Count(entryid) > 1) -- This runs after the aggregate count() function
A collection of notes, code snippets, instructions, et cetera for myself.
All text © Mattio Valentino.
All code is free content. Do what you will with it.
No comments:
Post a Comment