sql select only one column code example

Example 1: sql select all from one table and one column from another

SELECT myTable.*, otherTable.foo, otherTable.bar...

Example 2: select all same column value in sql

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