sql find same values in a column code example

Example 1: select all same column value in sql

SELECT RollId, count(*) AS c FROM `tblstudents` GROUP BY RollId HAVING c > 1 ORDER BY c DESC

Example 2: sql find all different values in column

SELECT DISTINCT
    column_name
FROM
    table_name;