SQL Tutorial

SQL Except

We usually join two tables in order to get a combined result set. But, there are cases when we want a result set which is available only in one table and not available in the….

SQL Between, MySQL Between Dates, Not Between

The SQL BETWEEN operator is used along with WHERE clause for providing a range of values. The values can be the numeric value, text value, and date. SQL BETWEEN operator is almost like SQL IN….

SQL Intersect

In a day to day scenario, we do meet with requirements where we need to get the common result set from multiple tables. In order to achieve such requirements, SQL has provided a feature called….

SQL Union, SQL Union All

In the real world, there are cases when we would like to merge the result set from two different SELECT queries. For such cases, SQL has provided a feature called Union. The literal meaning of….

Sql Is Null Is Not Null

SQL is null, SQL is not null

Sometimes we have columns where null values are allowed. In such cases, SQL IS NULL is a very useful operator. SQL IS NULL operator is used to checking if the value of a column is….

Sql In Not In Operators


SQL IN operator is used along with WHERE clause for providing multiple values as part of the WHERE clause. 1. SQL IN SQL IN operator is almost like having multiple OR operators for the same….

Sql Logical Operators

SQL AND, OR, NOT – SQL Logical Operators

SQL provides logical operators which helps in filtering the result set based on some condition. SQL logical operators that we will be discussing are AND, OR and NOT. These three are the most commonly used….

SQL Like – SQL Not Like

SQL LIKE is used with WHERE clause to search for a pattern for a column. Wildcards are the one which is used for specifying the pattern. There are two wildcards that are used with the….

SQL Order By

SQL Order By Clause

SQL Order By SQL Order By clause is used for sorting the result set. The sorting is done in either ascending or in descending order. The default order of sorting is sorting in ascending order…..

SQL Distinct

SQL Distinct, SQL Count Distinct, SQL Select Distinct

SQL Distinct keyword is used to select unique set of values for a column in a table. SQL Distinct It is very often that we have duplicate data available as part of the data storage…..

Generic selectors
Exact matches only
Search in title
Search in content