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.
  • 1435

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

CreateTable-in-sql.jpg


To insert only the top few records.

TopKeyword-with-Insert-in-SQL.jpg


OUTPUT:

Inset-TopRows-in-sql.jpg

© 2013 dotNetheaven. All rights reserved.