sql has many built-in functions for performing processing on string or numeric data. following is the list of all useful sql built-in functions −

• sql count function - the sql count aggregate function is used to count the number of rows in a database table.

• sql max function - the sql max aggregate function allows us to select the highest (maximum) value for a certain column.

• sql min function - the sql min aggregate function allows us to select the lowest (minimum) value for a certain column.

• sql avg function - the sql avg aggregate function selects the average value for certain table column.

• sql sum function - the sql sum aggregate function allows selecting the total for a numeric column.

• sql sqrt functions - this is used to generate a square root of a given number.

• sql rand function - this is used to generate a random number using sql command.

• sql concat function - this is used to concatenate any string inside any sql command.

• sql numeric functions - complete list of sql functions required to manipulate numbers in sql.

• sql string functions - complete list of sql functions required to manipulate strings in sql.