Category Archives: sql

SQL – Conversion Functions In SQL, the conversion functions are used to convert a value from one datatype to another. Generally, the form of the function names follows the convention datatype TO datatype. The first datatype is the input datatype. The second datatype is the output datatype. List of Functions Following is a list of […]

SQL – Datatype Functions The Data Type functions in SQL are a scalar functions that returns information about various data type values. Following are the SQL date type functions − Sr.No. Function & Description 1 Returns the number of bytes used to represent any expression and also counts the leading and trailing spaces of the […]

SQL – Useful Functions 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 − – The SQL COUNT aggregate function is used to count the number of rows in a database table. – The SQL AVG aggregate function selects the average […]