Tech Junkie Blog - Real World Tutorials, Happy Coding!: SQL: SUM() Aggregate Function

Thursday, July 22, 2021

SQL: SUM() Aggregate Function

The SUM() function is used to sum up all the values in the specified column.

SELECT SUM(UnitsInStock) AS TotalInventory
FROM Products

The above query gets the total number of units in stock for all products






6 comments:

  1. Replies
    1. Great Article Cloud Computing Projects

      Networking Projects

      Final Year Projects for CSE

      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. truck art, In India, You can see indian truck art on the road. who are cover with full of shayri such as Buri Nazar Wale Tera Muh Kala, and "Dekho Magar Pyaar Se" etc. Mostly that art is design on the front and backside of truck.

    ReplyDelete
  3. drumstick plant has many health benefits than other plants because it covers complete nutrition. They help build strong bones, brighten your skin and help your hair grow and smooth, etc. drumstick benefits they give you vitamins and minerals and they enhance your immunity and help purify your blood and they also used for many treatments such as bacterial infections, asthma and thyroid disorders etc.

    ReplyDelete

Search This Blog