Tech Junkie Blog - Real World Tutorials, Happy Coding!: SQL: MAX() And MIN() Aggregate Functions

Thursday, September 2, 2021

SQL: MAX() And MIN() Aggregate Functions

The MAX() function gets the highest value in the specified column, and the MIN() function gets the lowest value in the specified column

SELECT MAX(UnitPrice) AS HighestPrice, MIN(UnitPrice) AS LowestPrice
FROM Products

The query above gets the highest and lowest prices for the Products table in the Northwind database


 

 Previous: SQL: DATEPART Function


 at

15 comments:

  1. UnknownAugust 12, 2019 at 4:59 AM

    I am new here

    ReplyDelete
  2. carisAugust 28, 2019 at 6:57 AM

    Ace4sure is the website that deals in preparation material for the exam for many years. According to my exposure and research, this is the right platform where you can get exact 220-1001 Dumps.

    ReplyDelete
  3. InnomaticsSeptember 3, 2021 at 7:29 AM

    Data science course in hyderabad
    we provide classroom training on IBM certified Data Science at hyderabad for the individuals who believe hand-held training. We teach as per the Indian Standard Time (IST) with In-depth practical Knowledge on each topic in classroom training, 80 – 90 Hrs of Real-time practical training classes. There are different slots available on weekends or weekdays according to your choices.

    ReplyDelete
  4. keven johnOctober 13, 2022 at 6:33 AM

    SQL is a good data base everu backend developer have used this database.If you are looking to buy an online business management research topics service.You can easily make a call.

    ReplyDelete
  5. Emma StoneSeptember 2, 2024 at 2:44 PM

    This comment has been removed by the author.

    ReplyDelete
  6. AnonymousOctober 2, 2025 at 12:27 AM

    99757165A7
    takipçi al
    nautica swivel accent chair

    ReplyDelete
  7. AnonymousDecember 27, 2025 at 5:50 PM

    06E38102DE
    Takipçi Satın Al
    İndirim Kuponu
    Güvenilir Takipçi Satın Alma

    ReplyDelete
  8. AnonymousAugust 1, 2026 at 9:57 AM

    992D3E52
    Bolu
    Iğdır
    Yozgat
    Karabük
    Kırklareli
    Muş
    Kütahya
    Ağrı
    Ardahan

    ReplyDelete
  9. AnonymousAugust 4, 2026 at 2:23 AM

    4503622D
    Kırklareli
    Yalova
    Bartın
    Iğdır
    Zonguldak
    Karabük
    Uşak
    Şırnak
    Siirt

    ReplyDelete
  10. AnonymousAugust 17, 2026 at 1:12 PM

    1E51B1BA
    Kırıkkale
    Giresun
    Niğde
    Malatya
    Aksaray
    Bilecik
    Konya
    Antep
    Kırklareli

    ReplyDelete
  11. AnonymousAugust 30, 2026 at 10:51 PM

    D3CAF8FF
    Çiğli
    Beydağ
    Sorgun
    Dalaman
    Seferihisar
    Buharkent
    Nusaybin
    Yıldırım
    Atakum

    ReplyDelete
  12. AnonymousSeptember 3, 2026 at 8:54 AM

    9BAD0062
    Bismil
    Bornova
    Samandağ
    Aksu
    Edremit
    Ömerli
    Selçuk
    Antakya
    Bitez

    ReplyDelete
  13. AnonymousSeptember 6, 2026 at 3:44 AM

    FCC3330F
    Kilyos
    Boyabat
    Bağlar
    Nilüfer
    Bala
    Yakuplu
    Hendek
    Marmaris
    Demre

    ReplyDelete
  14. AnonymousSeptember 6, 2026 at 11:19 AM

    FB4E4CF5
    Başiskele
    Ağva
    Avşa
    Yıldırım
    Tatvan
    Kalkan
    Çatalca
    Bornova
    Balgat

    ReplyDelete
  15. AnonymousSeptember 7, 2026 at 9:36 AM

    A708198D
    Çatalca
    Tavşanlı
    Kemalpaşa
    Silopi
    Sarıçam
    Yakuplu
    Başiskele
    Çayırova
    Akçay

    ReplyDelete