sql query same value in one column diferrent value on another code example

Example: select all same column value in sql

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