Update Select Statement

UPDATE subject_section
SET facultyid =
(SELECT facultyid FROM ref_subject
WHERE subjectid = subject_section.subjectid) 

SQL count the same value in selected field

Count number of user with same DOB in DB 

SELECT dob,
COUNT(dob) AS NumOccurrences
FROM members
GROUP BY dob
HAVING ( COUNT(dob) > 0 )