I have created a table to store the employees educational details.The columns are empid,eduid(Foreign key).
primary key is both empid and eduid(to avoid entering the same data muliple times).A person may have four or five degrees at times. Can anybody suggest a query to search for persons whose educational is more than one degree(like person with M.B.A and B.E and M.A in public Administration ).All the degrees have eduid and can be received from education(eduid(Primary key),education) table.