Category: SQL

SQL IN operator is used to check if a value is present in a given list a result list returned by sub quarries. For example,

SQL MAX() function is used to return maximum value from a column of a table using a SELECT statement in sql. SQL MAX function syntax

SQL MIN() function is used to return minimum value from a column of a table using a SELECT statement. SQL MIN function syntax Syntax: SELECT

SQL SUM Function with query example – Sum function returns sum of all values of a column or expression. SUM Function returns the sum value

SQL AVG Function with query example – Avg function returns Average of all values of a column or expression. AVG function returns the average value

SQL Distinct statements with query example – Distinct statements in SQL is used to retrieve unique / different records from a column. It can return

SQL ORDER BY clause with query example – Order By clause is used to sort the data either in ascending order or in descending order

SQL GROUP BY clause with query example – Group By statement is used to group the common data in result set. For example,We have multiple

SQL HAVING Clause –  Having clause is used to retrieve records on the basis of some condition. It is same like SQL WHERE Clause except

SQL Count function with example – Count aggregate function returns total number of rows based on some condition like group by, distinct condition  and WHERE