Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
3.4k views
in Function by (240 points)
edited by

What is the difference between a CREATE and SELECT command in SQL? Give an example of CREATE command

Please log in or register to answer this question.

1 Answer

0 votes
by (54.8k points)
SELECT INTO command CREATE VIEW command
SELECT INTO creates a new table by extracting data from other table The CREATE VIEW creates view from a table.
Resides physically in the database. Not a part of the database's physical representation. 
Used to create backup copies of tables Not used for backup purpose
For eg. SELECT Lastname, FirstName INTO Person_Backup FROM Persons For eg. CREATE VIEW v_student AS SELECT Roll_no, Name, Class FROM student;

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...