Thread: Difference between VIEWS and SELECT statements

What's the difference between VIEWS and SELECT statements in SQL? why are we going for VIEWS instead of SELECT statements?

Question asked by visitor Henry

view is aphysical object which stores data logically.
the main thing is view does not take space in the disc.
you can go for either view or select statment , but if we go for a view means we are selection from a prepared / availabele list of records.

VIEW is a virtual table by which we can create a virtual table with columns from diff tables
It makes retrival of data from diff table lot more easier

we know views are stored as select statement in database
these are mainly useful to provide security to the data and to control the n/w traffic.
in realtime views play the major role