What is the difference between view and select in SQL?

Answer 1

SELECT creates temporary table for conditions you specified, and if you want to see the same table again you need to call SELECT with the same conditions all over again
VIEW creates and saves your query under a name, so when you need it, you can access it by just calling it's name - much faster and easier, you don't need to specify any of the conditions

Answer 2

https://www.sololearn.com/discuss/414825/?ref=app