1644 views

1 Answers

To find a duplicate id run the following query:

SELECT generic, COUNT(generic) FROM medicine_details WHERE generic_id BETWEEN 1 AND 1255 GROUP BY generic HAVING COUNT(generic) > 0

1644 views