SQL Sum()

SQL Sum()

07:36 / 0 Comments

The SUM() function returns the Total sum of a numeric column. Syntax : SELECT SUM(column_name) FROM table_name The "Custmast" table custcode custname city...

Read More

SQL Avg

SQL Avg

07:50 / 0 Comments

The AVG() function returns the average value of a numeric column. Syntax  SELECT AVG(column_name) FROM table_name The "custmast"  table custcode custname city qty...

Read More

SQL Count

SQL Count

07:48 / 0 Comments

The COUNT() function returns the number of rows that matches a specified criteria. The COUNT(column_name) function returns the number of values (NULL values...

Read More

SQL Between

SQL Between

07:45 / 0 Comments

The BETWEEN operator selects a range of data between two values. The values can be numbers, text, or dates. Syntax   SELECT column_name(s) ...

Read More

SQL Max() and Min()

SQL Max() and Min()

07:40 / 0 Comments

The MAX() function returns the largest value of the selected column. Syntax          SELECT MAX(column_name) FROM table_name  The "custmast" table...

Read More

SQL GROUP BY

SQL GROUP BY

07:35 / 0 Comments

The GROUP BY statement is used in conjunction with the aggregate functions to group the result-set by one or more columns. Syntax  SELECT...

Read More