select all same column value in sql
SELECT RollId, count(*) AS c FROM `tblstudents` GROUP BY RollId HAVING c > 1 ORDER BY c DESC
Are there any code examples left?
New code examples in category SQL
SELECT RollId, count(*) AS c FROM `tblstudents` GROUP BY RollId HAVING c > 1 ORDER BY c DESC