Top Keyword With Insert Statement In SQL
In this article i will explain how to use the top keyword in a insert query to insert only the top few records.
Introduction
Basically, most of us know about top, we can use it in a select query to get the top element from the query. But TOP can also be used with Insert, Delete and Update commands for the table as well. We will see how we can use TOP with Insert.
Syntax
insert into Table(column1, column2….)
select TOP (N) column1, column2…..
from Table1
or
insert TOP (N) into Table (column 1, column2….)
select column 1, column2….
from Table1
|
where N represents number of records.
Example
Firstly, create a table named Employee having columns (ID, F_Name, L_Name, Salary, Region and City) and insert some values.
Create table Employee(
ID int NOT NULL PRIMARY KEY,
F_Name varchar(20) NULL,
L_Name varchar(20) NULL,
Salary decimal(10,2) NULL,
Region varchar(10) NULL,
City varchar(20)NULL);
|
And the same structure for.Employee1. We have records in Employee table and we are retrieving the top data from it and insert it into Employee1 table.
Employee table data
To insert only the top few records.
OUTPUT: