Having (SQL)

A HAVING clause in SQL specifies that an SQL SELECT statement must only return rows where aggregate values meet the specified conditions.[1]: 125–127 

Use

HAVING and WHERE are often confused by beginners, but they serve different purposes. WHERE is taken into account at an earlier stage of a query execution, filtering the rows read from the tables. If a query contains GROUP BY, rows from the tables are grouped and aggregated. After the aggregating operation, HAVING is applied, filtering out the rows that don't match the specified conditions. Therefore, WHERE applies to data read from tables, and HAVING should only apply to aggregated data, which isn't known in the initial stage of a query.

To view the present condition formed by the GROUP BY clause, the HAVING clause is used.[clarification needed]

Examples

To return a list of department IDs whose total sales exceeded $1000 on the date of January 1, 2000, along with the sum of their sales on that date: 

SELECT DeptID, SUM(SaleAmount)
FROM Sales
WHERE SaleDate = '2000-01-01'
GROUP BY DeptID
HAVING SUM(SaleAmount) > 1000

Referring to the sample tables in the Join example, the following query will return the list of departments which have more than 1 employee: 

SELECT DepartmentName, COUNT(*) 
FROM Employee
JOIN Department ON Employee.DepartmentID = Department.DepartmentID 
GROUP BY DepartmentName
HAVING COUNT(*) > 1;

HAVING is convenient, but not necessary. Code equivalent to the example above, but without using HAVING, might look like: 

SELECT * FROM (
    SELECT DepartmentName AS deptNam, COUNT(*) AS empCount
    FROM Employee AS emp
    JOIN Department AS dept ON emp.DepartmentID = dept.DepartmentID
    GROUP BY deptNam
) AS grp
WHERE grp.empCount > 1;

References

  1. ^ PostgreSQL 16.1 Documentation (PDF). The PostgreSQL Global Development Group. 2023. Retrieved February 8, 2024.

Read other articles:

حرب المدن

  هذه المقالة عن حرب المدن فترة من خمسة مراحل جرت خلال الحرب العراقية الإيرانية (1980-1988). لمعانٍ أخرى، طالع حرب المدن (توضيح). حرب المُدن جزء من حرب الخليج الأولى معلومات عامة التاريخ 7-22 فبراير 1984 22 مارس - 8 أبريل 1985 17-25 يناير 1987 فبراير-أبريل 1987 يناير-فبراير 1988 البلد إيران ...

 

Arnon Soffer

Arnon SofferArnon SofferLahir24 Desember 1935 (umur 88)Tel-AvivKebangsaanIsraelPekerjaanProfesorDikenal atasRiset dalam masalah demografi, air, lingkungan hidup, politik dan strategi negara Israel. Arnon Soffer (lahir 24 Desember 1935) adalah seorang geografer dan profesor geografi dan ilmu lingkungan hidup asal Israel, yang mengkhususkan diri dalam masalah air dan demografi. Soffer adalah salah satu pendiri Universitas Haifa. Ia dikenal karena risetnya dalam masalah demografi, air, lin...

 

Heru Budi Hartono

Artikel biografi ini ditulis menyerupai resume atau daftar riwayat hidup (Curriculum Vitae). Tolong bantu perbaiki agar netral dan ensiklopedis.Heru Budi Hartono Penjabat Gubernur DKI JakartaPetahanaMulai menjabat 17 Oktober 2022PresidenJoko Widodo PendahuluAnies BaswedanPenggantiPetahanaKepala Sekretariat Presiden IndonesiaPetahanaMulai menjabat 20 Juli 2017PresidenJoko Widodo PendahuluDharmansjah DjumalaPenggantiPetahanaWali Kota Administrasi Jakarta Utara ke-8Masa jabatan13 Jan...

中国人民解放军陆军第十四集团军炮兵旅

陆军第十四集团军炮兵旅陆军旗存在時期1950年 - 2017年國家或地區 中国效忠於 中国 中国共产党部門 中国人民解放军陆军種類炮兵功能火力支援規模约90门火炮直屬南部战区陆军參與戰役1979年中越战争 中越边境冲突 老山战役 成都军区对越轮战 紀念日10月25日 陆军第十四集团军炮兵旅（英語：Artillery Brigade, 14th Army），是曾经中国人民解放军陆军第十四集团军下属�...

 

Daftar gubernur dan wakil gubernur di Indonesia

Gubernur dan Wakil Gubernur dari 38 provinsi di Indonesia yang sedang menjabat adalah sebagai berikut. Mulai menjabat merupakan awal periode kegubernuran yang saat ini sedang berjalan. Untuk gubernur sementara, merupakan tanggal pengangkatan atau pelantikan sebagai penjabat/pelaksana tugas/pelaksana harian gubernur. Provinsi Foto Gubernur Gubernur Foto Wakil Gubernur Wakil Gubernur Mulai menjabat Selesai menjabat(Direncanakan) Aceh Daftar Gubernur / Wakil Gubernur Bustami Hamzah(penjabat) low...

 

Jennette McCurdy (album)

Jennette McCurdyAlbum studio karya Jennette McCurdyDirilis05 Juni 2012 (2012-06-05)GenreCountryDurasi34:40LabelCapitol NashvilleProduserPaul WorleyJay DeMarcusKronologi Jennette McCurdy Jennette McCurdy (EP)(2012)Jennette McCurdy (EP)2012 Jennette McCurdy(2012) Singel dalam album Jennette McCurdy Generation LoveDirilis: April 25, 2011 Jennette McCurdy adalah sebuah album studio pertama dari penyanyi-penulis lagu Amerika Serikat, Jennette McCurdy. album ini dirilis pada 5 Juni 2012 vi...

Stadion Bank of America

Bank of America StadiumThe Vault Informasi stadionNama lamaCarolinas Stadium (direncenakan)Ericsson Stadium (1996–2004)PemilikCarolinas Stadium CorpOperatorCarolinas Stadium CorpLokasiLokasi800 South Mint StreetCharlotte, North Carolina 28202Koordinat35°13′33″N 80°51′10″W / 35.22583°N 80.85278°W / 35.22583; -80.85278Koordinat: 35°13′33″N 80°51′10″W / 35.22583°N 80.85278°W / 35.22583; -80.85278KonstruksiMulai pembangunan...

 

Kajen, Pekalongan

Untuk kegunaan lain, lihat Kota Kajen. KajenKecamatanPeta lokasi Kecamatan KajenNegara IndonesiaProvinsiJawa TengahKabupatenPekalonganPemerintahan • CamatMuhammad ArifinPopulasi • Total74,249 jiwaKode Kemendagri33.26.08 Kode BPS3326080 Luas75,15 km²Desa/kelurahan25 Kajen (Jawa: ꦏꦗꦼꦤ꧀, translit. Kajen) adalah kecamatan di Kabupaten Pekalongan, Jawa Tengah, Indonesia. Kecamatan ini merupakan ibu kota Kabupaten Pekalongan karena nama Kecamatan Pek...

 

Pure Land Buddhism

School of Mahāyāna Buddhism Amitābha and his attendant bodhisattvas Avalokiteśvara (right) and Mahāsthāmaprāpta (left) Part of a series onMahāyāna Buddhism Teachings Bodhisattva Buddhahood Mind of Awakening Buddha-nature Skillful Means Transcendent Wisdom Transcendent Virtues Emptiness Two truths Consciousness-only Three bodies Three vehicles Non-abiding Nirvana One Vehicle Bodhisattva Precepts Bodhisattva vow Bodhisattva stages Pure Lands Luminous mind Dharani Three Turnings Buddhas...

Grand Prix de Tennis de Toulouse 1985

Grand Prix de Tennis de Toulouse 1985 Sport Tennis Data 7 ottobre – 13 ottobre Edizione 4a Superficie Cemento indoor Campioni Singolare Yannick Noah Doppio Ricardo Acuña / Jakob Hlasek 1984 1986 Il Grand Prix de Tennis de Toulouse 1985 è stato un torneo di tennis giocato sul cemento indoor. È stata la 4ª edizione del Grand Prix de Tennis de Toulouse, che fa parte del Nabisco Grand Prix 1985. Il torneo si è giocato a Tolosa in Francia, dal 7 al 13 ottobre 1985. Indice 1 Campioni 1.1 Si...

 

Boeing 747

В статье есть список источников, но не хватает сносок. Без сносок сложно определить, из какого источника взято каждое отдельное утверждение. Вы можете улучшить статью, проставив сноски на источники, подтверждающие информацию. Сведения без сносок могут быть удалены. (8 дек...

 

Wilfred Curtis

Wilfred Austin CurtisNickname(s)WilfBorn(1893-08-21)21 August 1893Havelock, Ontario, CanadaDied14 August 1977(1977-08-14) (aged 83)Toronto, Ontario, CanadaAllegiance CanadaService/branchCanadian Expeditionary Force Royal Naval Air Service Royal Air Force Royal Canadian Air ForceYears of service1916–19191933–1953RankAir MarshalBattles/warsWorld War IWorld War IIAwardsOfficer of the Order of CanadaCompanion of the Order of the BathCommander of the Order of the British Empire...

Job 5

One of the chapters in Hebrew Bible Job 5← chapter 4chapter 6 →The whole Book of Job in the Leningrad Codex (1008 C.E.) from an old fascimile edition.BookBook of JobHebrew Bible partKetuvimOrder in the Hebrew part3CategorySifrei EmetChristian Bible partOld TestamentOrder in the Christian part18 Job 5 is the fifth chapter of the Book of Job in the Hebrew Bible or the Old Testament of the Christian Bible.[1][2] The book is anonymous; most scholars believe it was wr...

 

2002 Connecticut State Treasurer election

2002 Connecticut State Treasurer election ← 1998 November 5, 2002 2006 →   Nominee Denise L. Nappier Ross Garber Party Democratic Republican Popular vote 527,216 389,304 Percentage 56.0% 41.3% County resultsNappier:      40–50%      50–60%      60–70% State Treasurer before election Denise L. Nappier Democratic Elected State Treasurer Denise L. Nappier Democratic Elections in Conn...

 

Fisk Generating Station

Decommissioned electric power generating plant Fisk Generating StationCountryUnited StatesLocationPilsen neighborhood of ChicagoCoordinates41°51′01″N 87°39′12″W / 41.85028°N 87.65333°W / 41.85028; -87.65333StatusDecommissionedCommission date1968 (current units)Decommission date2012Owner(s)Midwest GenerationThermal power station Primary fuelSubbituminous coal, keroseneTurbine technologySteam (coal), Combustion turbine (kerosene)...

National Register of Historic Places listings in Dubois County, Indiana

Location of Dubois County in Indiana This is a list of the National Register of Historic Places listings in Dubois County, Indiana. This is intended to be a complete list of the properties and districts on the National Register of Historic Places in Dubois County, Indiana, United States. Latitude and longitude coordinates are provided for many National Register properties and districts; these locations may be seen together in a map.[1] There are 16 properties and districts listed on ...

 

Stasiun Nishi-Funabashi

JB30 JM10 Stasiun Nishi-Funabashi西船橋駅Pintu masuk utara pada bulan September 2019Lokasi4-27-7 Nishifuna, Funabashi-shi, Chiba-kenJepangOperator JR East (manajer) Tokyo Metro Tōyō Rapid Railway Jalur JB Jalur Chūō-Sōbu JM Jalur Musashino JE Jalur Keiyo Jalur Tokyo Metro Tōzai Jalur Tōyō Rapid Railway Informasi lainKode stasiun JB30 (Chūō-Sōbu Line) JM10 (Musashino Line, Keiyō Line) T-23 (Tozai Line) TR01 (Toyo Rapid Railway Line) SejarahDibuka10 November 1958Operasi layanan ...

 

MV London Statesman

Dry cargo ship This article is about the 1963-built cargo ship. For the 1943-built Empire ship renamed London Statesman, see SS Empire Celia. History United Kingdom NameMV London Statesman (1963–79) Port of registry London (1963–79) BuilderUddevallavarvet AB, Uddevalla[1] Cost£1,310,000[2] Yard number191[1] Launched30 January 1963[1] Renamed Agia Marina (1979–81) Olympiakos (1981–83) Skaros (1983–84)[1] IdentificationUK official number 304576...

الحسنية الدرامي

هذه المقالة يتيمة إذ تصل إليها مقالات أخرى قليلة جدًا. فضلًا، ساعد بإضافة وصلة إليها في مقالات متعلقة بها. (مارس 2020) الحسنية الدرامي معلومات شخصية الميلاد 10 ديسمبر 1956 (68 سنة)  الجنسية المغرب  الحياة العملية المهنة منافسة ألعاب القوى  الرياضة ألعاب القوى  تعديل مصدر...

 

Superman

Para otros usos de este término, véase Superman (desambiguación). Superman Personaje de DC Comics Estatua del personaje en Metropolis (Illinois)Primera aparición Action Comics#1 (junio de 1938)Creado por Jerry Siegel (escritor)Joe Shuster (artista)Interpretado por 13 actoresPelículasKirk Alyn (1948-1950)George Reeves (1951-1954)Christopher Reeve (1978-1987-2006)Brandon Routh (2006)Henry Cavill (2013-2022)David Corenswet (2025-presente)Series TelevisivasGeorge Reeves (1952-1958)John Newt...