SQL: CREATE VIEW or SELECT?! | Sololearn: Learn to code for FREE!
¡Nuevo curso! ¡Todo programador debería aprender IA Generativa!
Prueba una lección gratuita
+ 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 Respuesta
+ 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