How to get the students who are in more than one group mysql
Related FAQs
- how to find which tables use innodb in mysql
- How to search a tablename in schema
- How to get the students who are in more than one group mysql
- How to find the duplicate rows by comparing two columns in a table mysql
- How to get the length of a string in a column mysql
- How to get the records posted in this month in mysql
- how to find duplicate rows in a table based on specific column
- how to determine constant values in mysql
- how to concatenate all rows of a particular column in a table mysql
- How to connect the mysql from command prompt
Using aggregate function and
Fri, 09/03/2010 - 13:47 — shashiUsing aggregate function and group by , Having clause you can get the students who are in more than one group
SQL
SELECT
COUNT(*) AS cnt,student_id
FROM
student_groups
GROUP BY
student_id HAVING COUNT(*)>1