sql data types

SQL SELECT AVG The AVG is an aggregate function in SQL which calculates the average of values of the numerical column from…

SQL SELECT MAX The MAX is an aggregate function in Structured Query Language that returns the largest value from the multiple values…

SQL SELECT MIN The MIN is an aggregate function in SQL which returns the smallest value from the multiple values of the…

SQL Stored Procedure A stored procedure in Structured Query Language is a group of logical statements stored in the database for performing…

SQL EXCEPT Usually, we use a JOIN clause to get the combined result from more than one table. Sometimes, we need a…

SQL String Functions In this article, you will learn about the various string functions of Structured Query Language in detail with examples.…

SQL Formatter The lengthy code becomes difficult to interpret. There is a large amount of unformatted SQL code while reading SQL scripts,…

SQL Subquery The Subquery or Inner query is an SQL query placed inside another SQL query. It is embedded in the HAVING…

SQL get month from the date To remember important dates, we can store them in the database tables of SQL. There may…

SQL UNION UNION is an SQL operator which combines the result of two or more SELECT queries and provides the single set…