Sunday, October 21, 2018

Select InTo

Select InTo
* it is used to copy data from one table to another.
* select data from one table and insert into new table.

Example:
Copy All column into new table.

SELECT *
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;


No comments:

Post a Comment

How to use SQL pagination using LIMIT and OFFSET

  How to extract just a portion of a larger result set from a SQL SELECT. LIMIT n is an alternative syntax to the FETCH FIRST n ROWS ONLY. T...