SQL Tutorial 11: Create Views
View is another object that you could store in database.
As pre-cursor in preparing reports, view is an effective simplified table from SELECT JOINed query. You don’t need to re-execute a SELECT JOIN that you have defined in the past. Once you have set the correct join, save it on a view.
This video tutorial shows on how to create views from given SELECT LEFT JOINs. You may see the structure of a view as if you are describing a table. You can distinguish view from other objects inside a database as you list it with tables.
It also shows the work around on how to sort in a specified ORDER BY clause and save it on a view. Normally, view does not accept script with an order by.
It includes on how to join table with itself by simply setting up a different alias name.
In questa pagina del sito puoi guardare il video online SQL Tutorial 11: Create Views della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Jerry Esperanza 04 maggio 2015, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,275 volte e gli è piaciuto 5 spettatori. Buona visione!
