SQL: query occurrences of multiple fields in a table

SELECT id, name , email,
COUNT(id) AS NumOccurrences
FROM student_record
GROUP BY id, name, email
HAVING ( COUNT(id) > 1 );
- student_record is table name.
- id, name, email are column names.
- counting more than one occurrences for above column.


by Uki D. Lucas on Thursday, July 02, 2009
find similar posts:
As an Amazon Associate I earn from qualifying purchases.

My favorite quotations..


“A man should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly. Specialization is for insects.”  by Robert A. Heinlein

"We are but habits and memories we chose to carry along." ~ Uki D. Lucas

Popular Recent Articles