Apply for Zend Framework Certification Training

Mysql





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 swap two variable value in php >



Ask a question



  • Question:
    {{questionlistdata.blog_question_description}}
    • Answer:
      {{answer.blog_answer_description  }}
    Replay to Question


Back to Top