Stay informed about any major changes. Click here to subscribe
How to create a view
A database view serves to present the
data so as to be easily understood. A view can combine several tables,
display only one part of a table, calculate the average values, and present
the data from the tables in a number of other ways. We will take, as an
example, request to calculate the total number of orders per day. The
Orders table contains the data about all the orders as illustrated below:
ORDERS TABLE
The four columns include the data on every individual order. The video
demonstrates how all the data from the Orders table can easily be grouped
by OrderDate column. We will create a view showing the exact number of
orders for every day in a year. The resulting presentation generated by
the View using the Orders table will be as illustrated below:
