Category: SQL

The SQL BETWEEN operator is used to fetch records between a given range. For example, Let’s say, we want to retrieve all books within a

SQL create table example – Learn how to create a table in MySQL database with example and important points. Create Table statement allows you to

SQL drop table with example in MySql – Learn how to remove table from a database. SQL drop table statement do the following. Removes one

SQL CHECK CONSTRAINT example – Learn how to limit value range for columns in the table in MySQL database with example and important points. POINTS

SQL where clause with query example – Where clause in SQL is used to fetch records on the basis of some condition. For example, List

Example of using SQL Logical operators viz AND, OR and NOT. Logical operators are used to test two or more conditions in an SQL Select

The NOT IN operator checks a value within a set of values, and retrieve the rows from the table which are NOT matching. This is

SQL Create database Example – Learn how to create database in MySQL with example and important points. Also, know how to select database in MySQL

SQL Rename column example-  Learn how to modify column name of a table in MySQL database with examples when there is either no data or

SQL drop column from table example-Learn how to remove column from a table in MySQL database with examples and important points. To drop or remove