+ 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
2 Answers
+ 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