0 votes
41 views
in Computer by (65 points)
edited by

What is the difference between a WHERE clause and a HAVING clause of SQL SELECT statement.

Please log in or register to answer this question.

1 Answer

0 votes
by (53.0k points)

WHERE is used to filter records before any groupings take place. HAVING is used to filter values after they have been groups. Only columns or expressions in the group can be included in the HAVING clause's condition.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...