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 mysql stored procedure to insert data >



Ask a question



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

(+91)-9910699802
Become A Member     Become A Teacher
Back to Top