Dot Net CMS Portal

Submitted by Nathworks on
Free Open Source Asp.Net CMS Portal Simple setup, easy to manage everyday content. This is only one Asp.Net CMS Portal for end users not for developers. No database only XML, Easy to embed any open source, premier, iPhone templates. More then 40 pre build CMS controls. Demo sites, Free CMS Packs, Video tutorials, and many more.. http://www.dotnetcmsportal.com

SQL AVG() Function

Submitted by admin on

The AVG function calculates the average of a specified column. It works only on a numeric column. It first sums up all data and then divides it by the total number of rows.For example if the sum of 5 items is 10 then average is 10/5 = 2.

SQL AVG() Syntax

SQL FIRST Function

Submitted by admin on

The FIRST function returns the first value of the selected column. FIRST function is not standard SQL function so it cannot be used with other DBMS like MySQL. However this is very useful with MS Access OR SQL Server.

SQL FIRST() Syntax

Subscribe to