SQL: CREATE VIEW or SELECT?!

Question

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

Answer 1

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