How can I check a column in a database to see if it contains unique data.

Question 1

Question 2

Here is one way to check. In this case, if the following query returns any results, we know that the medicationDescription contains duplicates

SELECT medicationDescription, COUNT(medicationDescription) FROM Meds GROUP BY medicationDescription HAVING COUNT(medicationDescription) > 1

rich-c-2789 · Answer 1 · 2013-07-09T19:01:29+0000

Here is one way to check. In this case, if the following query returns any results, we know that the medicationDescription contains duplicates

SELECT medicationDescription, COUNT(medicationDescription) FROM Meds GROUP BY medicationDescription HAVING COUNT(medicationDescription) > 1

Categories

How can I check a column in a database to see if it contains unique data.

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

Please log in or register to add a comment.