Databases for Windows / Database Blog / Organizer Advantage, Handy Library, SQL Tutor / SQL Functions / SQL Tutor, FUNCTIONS, Sum
28/05/2024SQL SUM function
SUM
To display the total cost of the library items using the SQL SUM function in the library table, you can use the following SQL query:
SELECT SUM(price) AS total_cost FROM library;
In this query, the SUM(price) function calculates the total cost of all the items in the library table. The price data field contains the book's cost.
Database Blog
Firebird SQL Tutor
SQL Select
- Select, Where
- Select, Where Compare
- Select, Where Equal
- Select, Where Greater Than
- Select, Where Less Than
- Select, Where Greater Than, Equal
- Select, Where Less Than, Equal
- Select, Where Not Equal
- Select, Where Between
- Select, Where IN
- Select, Where LIKE
- Select, Where Wildcards
SQL Select AND, OR, NOT
SQL Select ORDER BY
SQL Select DISTINCT
SQL FUNCTIONS
- Functions, Count
- Functions, Sum
- Functions, Avg
SQL RESERVED WORDS
SQL UPDATE
Database Software for Windows:
Handy Managers
Organizer Advantage
Label Printer Advantage
Organizer Advantage Database:
Organizer Advantage, Simple Database Solutions
Organizer Advantage, Business Database Solutions
Copyright © 2024 · All Rights Reserved · PrimaSoft PC