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

Text Security

Submitted by Naveen Kumar on
The Software security system is totally enhanced with the Features that enable us to feel the real time environment. Today’s world is mostly employing the latest networking techniques instead of using stand alone pc’s .Due to globalization the information is shared through sending memos, E-mails and Fax .It is not secure and reliable . There is threat of security by the eavesdroppers, hackers and

Import Daily Orders From Magento

Submitted by JanzellJurilla on
Hi People, I'm sharing a miscellaneous script that allow Magento Store Owner to dump their orders from Magento Database and forward it to their Fulfillment Center via Email. Learn more about this snippets. Things you need to change in the code: #credentials details $server_host = 'your host'; $sql_username = 'your username'; $sql_password = 'your password';
Subscribe to