Category Archives: SQL

SQL Command Types – DDL, DQL, DML, DCL & TCL

SQL Command Types

SQL Commands are categorized into DDL, DQL, DML, DCL & TCL. Learn the commands included in each of these categories with their purpose and explanation. SQL Command Types Structured Query Language (SQL) is used to create a database(s) and perform different operations on it. There is a huge list of operations that can be performed […]

SQL Wildcard Characters

SQL Wildcard Characters

This is a detailed tutorial of SQL Wildcard Characters. Learn to use different wildcards to find matching pattern strings with the LIKE operator. Use of SQL Wildcard Characters Wildcard characters are used in the SQL Like Operator to create different patterns for which you want to find the values in the database tables. A single […]

SQL BETWEEN Operator

SQL BETWEEN Operator

This is a detailed tutorial on SQL BETWEEN Operator. Learn how to filter values that lie between a range using the BETWEEN Operator in the WHERE Clause. Use of SQL Between Operator SQL Between Operator is used within the SQL WHERE clause to filter those records for which particular column values lie between a certain […]