Category Archives: sql

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 […]

SQL – Common Table Expression (CTE) Table of content A Common Table Expression (CTE) can make it easier to manage and write complex queries by making them more readable and simple, like database views and derived tables. We can reuse or rewrite the query by breaking down the complex queries into simple blocks. The SQL […]