HAVING clause
HAVING bayonoti SQL ga qo'shilgan, chunki WHERE kalit so'zi agregat funksiyalar bilan ishlatilmaydi.
SQL HAVING Bayonoti
HAVING bayonoti SQL ga qo'shilgan, chunki WHERE kalit so'zi agregat funksiyalar bilan ishlatilmaydi.
HAVING Sintaksisi
Demo Ma'lumotlar Bazasi
Ushbu o'quv qo'llanmada Northwind namunaviy ma'lumotlar bazasidan "Customers" jadvalidan bir tanlov:
CustomerID | CustomerName | ContactName | Address | City | PostalCode | Country |
---|---|---|---|---|---|---|
1 | Alfreds Futterkiste | Maria Anders | Obere Str. 57 | Berlin | 12209 | Germany |
2 | Ana Trujillo Emparedados y helados | Ana Trujillo | Avda. de la Constitución 2222 | México D.F. | 05021 | Mexico |
3 | Antonio Moreno Taquería | Antonio Moreno | Mataderos 2312 | México D.F. | 05023 | Mexico |
4 | Around the Horn | Thomas Hardy | 120 Hanover Sq. | London | WA1 1DP | UK |
5 | Berglunds snabbköp | Christina Berglund | Berguvsvägen 8 | Luleå | S-958 22 | Sweden |
SQL HAVING Misollari
Quyidagi SQL bayonoti har bir mamlakatdagi mijozlar sonini ro'yxatga oladi. Faqat 5 dan ortiq mijozga ega mamlakatlarni qo'shadi:
Quyidagi SQL bayonoti har bir mamlakatdagi mijozlar sonini yuqoridan pastga tartibda ro'yxatga oladi (faqat 5 dan ortiq mijozga ega mamlakatlar):
Demo Ma'lumotlar Bazasi
Ushbu o'quv qo'llanmada Northwind namunaviy ma'lumotlar bazasidan "Orders" jadvalidan bir tanlov:
OrderID | CustomerID | EmployeeID | OrderDate | ShipperID |
---|---|---|---|---|
10248 | 90 | 5 | 1996-07-04 | 3 |
10249 | 81 | 6 | 1996-07-05 | 1 |
10250 | 34 | 4 | 1996-07-08 | 2 |
Va "Employees" jadvalidan bir tanlov:
EmployeeID | LastName | FirstName | BirthDate | Photo | Notes |
---|---|---|---|---|---|
1 | Davolio | Nancy | 1968-12-08 | EmpID1.pic | Education includes a BA... |
2 | Fuller | Andrew | 1952-02-19 | EmpID2.pic | Andrew received his BTS... |
3 | Leverling | Janet | 1963-08-30 | EmpID3.pic | Janet has a BS degree... |
Boshqa HAVING Misollari
Quyidagi SQL bayonoti 10 dan ortiq buyurtma bergan xodimlarni ro'yxatga oladi:
Quyidagi SQL bayonoti "Davolio" yoki "Fuller" xodimlari 25 dan ortiq buyurtma berganligini ro'yxatga oladi: