Databases for Windows / Database Blog / Organizer Advantage, Handy Library, SQL Tutor / SQL Functions / SQL Tutor, FUNCTIONS, Avg
28/05/2024Functions, AVG
AVG
To display the average price of the book in the library table using SQL avg function, you can use the following query:
SELECT AVG(price) AS average_price FROM library;
In this query, we are using the AVG function to calculate the average price of the books stored in the price field of the library table. The result will be displayed as average_price.
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