Categories of SQL Functions useful methods Name

Categories of SQL Functions:

1. Aggregate Functions: These operate on a group of rows and return a single result (used in conjunction with GROUP BY).

   • Examples: AVG(), SUM(), COUNT(), MAX(), MIN()

2. Scalar Functions: These operate on a single value and return a single result.

   • Examples: UPPER(), LOWER(), LENGTH(), CONCAT(), ROUND()

3. String Functions: Used to manipulate string (text) data.

   • Examples: CONCAT(), TRIM(), SUBSTRING(), REPLACE()

4. Date Functions: Used to manipulate date and time values.

   • Examples: NOW(), DATEADD(), DATEDIFF(), YEAR(), MONTH()

5. Mathematical Functions: Used to perform mathematical calculations.

   • Examples: ROUND(), CEILING(), FLOOR(), ABS(), POW()

6. Conversion Functions: Used to convert one data type to another.

• Examples: CAST(), CONVERT()

Categories of SQL Functions useful methods Name