SQL Tutorials

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 …

The “NOT IN” operators will return records that do not match the values given in the IN clause. The following example will make it clear.

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.

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

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

To remove the duplicate records for the data fetched with SELECT statement, you may use the DISTINCT clause as shown in the examples in this tutorial.

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

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.

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.

The MS SQL Server and MySQL database ROUND function is used to return the number rounded to the specified precision.

The SQL SUM is an aggregate function that is used to return the sum of numeric column for all the values or DISTINCT values.

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.