Sql compare two columns for differences

Here we are going to see how we can compare the columns of two different tables in SQL. We will be taking a few examples to see how we can do this in different ways.

Overview :
In this, we will understand overview of SQL query for required operation to perform How to compare columns in two different tables in SQL.

We will understand each concept with the help of examples. 

Step-1: Creating database :
To create the database use the following SQL query as follows.

Syntax  –

create database_name;

Example –

create STUDENTS_DATA

Step-2: Using the database :
To use this database as follows.

Syntax –

use database_name;

Example –

use STUDENT_DATA

Step-3: Creating table :
Creating Table for making queries as follows.

Table-1: Syntax – 

create table table_name ( column1 type, column2 type, ...

);

Example –

create table studentData1 ( roll_number int primary key, firstname varchar(100), lastname varchar(100), marks int );

Step-4: Inserting records :
Inserting r

how to check column value length in sql

how to check column default value in sql