SELECT DISTINCT student_class ,student_id, student_name FROM student SELECT student_class ,student_id, student_name FROM student GROUP BY student_class
HI viewers
Lets talk about eleminating duplicate entry from table
When we retrieve data from Table we get duplicate date like city first name
so to avoid these we have to use DISTINCT keyword in mysql
In mysql we have another function which is used for uniquenes
GROUP BY
GROUP BY and DISTINCT have almost same functionality
Difference is GROUP BY Arrange data in Order but DISTINCT Does not
Query will be
< Select query in mysql mysql stored procedure to insert data >