Category: SQL

The SQL BETWEEN operator is used to fetch records between a given range. For example, Let’s say, we want to retrieve all books within a

The NOT IN operator checks a value within a set of values, and retrieve the rows from the table which are NOT matching. This is

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,

Example of using SQL Logical operators viz AND, OR and NOT. Logical operators are used to test two or more conditions in an SQL Select

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 where clause with query example – Where clause in SQL is used to fetch records on the basis of some condition. For example, List

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 ORDER BY clause with query example – Order By clause is used to sort the data either in ascending order or in descending order

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

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