Tags → Sql Function Example

Using SUM Function in An SQL Statement

Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

Formatting Date/Time value in SQL query

Learn how to use MySQL embedded function to format Date/Time field value just right in the SQL query string. For example another way is to use PHP, but it is slower and inconvenient. This tutorial will show you both examples for the same goal.

• Categories
  • PHP →
  • Tips and Tutorials →
  • Database-Related
• Platforms
  • Linux
• Licenses
  • Freeware