Hi there,
below are sample SQL statement.. hope it helps you to get started.. good luck my fren.. :)
The COUNT(*) function returns the number of selected rows in a selection
-
SELECT COUNT(*) FROM table
-
The COUNT(column) function returns the number of rows without a NULL value in the specified column
-
SELECT COUNT(column) FROM table
-
The MAX function returns the highest value in a column. NULL values are not included in the calculation
-
SELECT MAX(column) FROM table
-
The MIN function returns the lowest value in a column. NULL values are not included in the calculation
-
SELECT MIN(column) FROM table
-