SQL Tutorial

SQL Insert Into Select

In the real world of SQL, imagine if there is a situation when you need to copy data from one table to another table. SQL has an answer for this and the answer is “SQL….

SQL Functions

In day to day usage of SQL, there is a time when we need to manipulate data based on the type of data. For example, in a table which comprises prices we need to get the….

SQL Subquery – Nested Query in SQL

In the real world, there are times when we need a particular set of data but we don’t have the exact details for getting the data set. In such cases, we try to get the….

SQL Commit And Rollback

The most important aspect of a database is the ability to store data and the ability to manipulate data. COMMIT and ROLLBACK are two such keywords which are used in order store and revert the process….

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….

Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages