BETWEEN Operator in SQL


The SQL BETWEEN operator is used to specify a range to test. You may use BETWEEN operator with SELECT statement for retrieving data for the given range. The BETWEEN operator can also be …

TRUNCATE command in SQL


The SQL TRUNCATE command is used to remove table data completely. You may also remove table data by using DELETE statement, however, there are certain differences as you execute the two.

TRIM function in SQL

SQL TRIM column

The SQL TRIM function is used for removing the leading and trailing spaces from the given string. In this tutorial, I will show using in SQL Server, MySQL and Oracle


An infographic showing various types of JOINs in SQL. The queries are shown for INNER JOIN, LEFT JOIN, RIGHT JOIN, and OUTER JOIN. Enhance your relational database knowledge with this visual tutorial.

In RDBMS, the SQL JOIN clause is the way for combining records of different tables. The tables are joined by logical relationships.

GROUP BY clause in SQL

Explore the power of grouping rows and performing aggregate calculations with our comprehensive infographic.

Discover the essence of SQL GROUP BY with 10 insightful queries explained for SQL Server. Master data organization and aggregation for enhanced SQL skills.

SQL MAX function


The SQL MAX function is used to return the maximum value for the specified column in the SELECT statement. If the specified column is character based then highest value in the collating sequence is returned.


Visual Guide to SQL ORDER BY: Enhance your database querying skills by understanding single and multi-column sorting with the ORDER BY clause.

Discover the power of SQL ORDER BY with 9 queries. Learn to sort results in ascending and descending order, handle NULL values, and optimize queries for efficient data organization. Elevate your SQL skills with our practical guide.

SQL COUNT Function

A Visual tutorial of SQL COUNT Function: Learn to count total rows, non-null values, GROUP BY, HAVING with COUNT - examples and syntax.

To get the count of rows returned by select statement, use the SQL COUNT function. In this tutorial, I will show 9 queries to learn about this.