When checking the integrity of your data, it may be necessary to check your tables for duplicate records. By grouping these records, you can eliminate the unique records from your result set so that you can view just the records that contain duplicated values, making it easier to remove them.

For example, we will work with a table namedStudents and we will look for duplicate values in the Email_Address column.