SQL: CREATE VIEW or SELECT?! | Sololearn: Learn to code for FREE!
Nouvelle formation ! Tous les codeurs devraient apprendre l'IA générative !
Essayez une leçon gratuite
+ 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 Réponse
+ 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