Connect with us

SQL Function

SQL Min()

mm

Published

on

Hi, Thank you for reading my article. I am Victor, a professional blogger from Jaipur, India.I started webetutorial for blogging & sharing solution for developer questions, and now it’s empowering globally by helping them to make money.I am writing about starting & managing a blogs, WordPress, Magento, Social Media, SEO, Marketing, making money online, Investment, Finance, Gadgets, Fitness and more.

Continue Reading
Advertisement
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

one × 4 =

SQL Function

SQL Avg()

mm

Published

on

The AVG() returns the average value of a numeric column.
Syntax:-
SELECT AVG(column_name) FROM table_name;
Example:-
The subsequent SQL gets the average value of the “Price” column from the “Hosting” table:-

SELECT AVG(Price) AS PriceAverage FROM Hosting;

OR

SELECT HostingName, Price FROM Hostings WHERE Price>(SELECT AVG(Price) FROM Hostings);

Also Read :   SQL Len()
Continue Reading

Trending