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
Category: SQL
SQL tutorial ( Structured Query Language) with examples and notes.
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