SQL: CREATE VIEW or SELECT?! | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 3

SQL: CREATE VIEW or SELECT?!

I'm just confused... what is the difference between CREATE VIEW and SELECT... and where/when to use either of them!

5th Feb 2018, 9:25 PM
Muhammad Ebrahim
1 Answer
+ 3
A view is basically a stored select or a virtual table that has the information of a query. A select on the other hand is a way to consult and get the information you have in your DB
5th Feb 2018, 11:46 PM
Mickel
Mickel - avatar