MVSFORUMS.com :: View topic - Insert Into... Select

MVSFORUMS.com
A Community of and for MVS Professionals

FAQ

Quick Manuals

Profile

Insert Into... Select

MVSFORUMS.com Forum Index -> Database

View previous topic :: View next topic

Author

Message

edkir98
Beginner

Joined: 27 Aug 2007
Posts: 102
Topics: 42
Location: Chennai

Posted: Mon Sep 22, 2008 2:15 am Post subject: Insert Into... Select

Is it possible to use INSERT INTO statement with SELECT for only some rows..like.. I want to insert only the first 100 rows from the select statement..

for ex. a statement like this

Code:

INSERT INTO <table name>
SELECT field1,
field2,
field3
FROM table1
INSERT FIRST 100 ROWS ONLY

_________________
Thanks

Display posts from previous:

	MVSFORUMS.com Forum Index -> Database	All times are GMT - 5 Hours
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum