Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
1.2k views
in Data Manipulation Through SQL by (49.1k points)
closed by

What is the use of HAVING clause. Give an example python script?

1 Answer

+1 vote
by (54.8k points)
selected by
 
Best answer

Having clause is used to filter data based on the group functions. This is similar to WHERE condition but can be used only with group functions. Group functions cannot be used in WHERE Clause but can be used in HAVING clause.

Example

import sqlite3

connection= sqlite3.connect(“Academy.db”) cursor = connection. cursor( )

cursor.execute(“SELECT GENDER,COUNT(GENDER) FROM Student GROUP BY GENDER HAVING COUNT(GENDER)>3 “)

result = cursor. fetchall( )

co= [i[0] for i in cursor, description]

print(co)

print( result)

OUTPUT

[‘gender’ , ‘COUNT(GENDER)’]

[(‘M’ , 5)]

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.

...