Bissoy.com
Doctors Medicines MCQs Q&A

1628 views

1 Answers

SELECT
generic,
COUNT(generic)
FROM
medicine_details
GROUP BY generic
HAVING COUNT(generic) > 1;

//generic = column name
//medicine_details = table name

1628 views

Related Questions

How to see MySQL version?
2 Answers 1646 Views