PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement. Every time a view is accessed, its data are sorted and displayed as specified by the ORDER BY clause. This sorting on ...

[Click on image for larger view.] Figure 1. All right, we are good to go with continuing to create some users on the SQL server. First off, let's take a quick look at the existing users and see how ...

create the view because it is only a T-SQL query definition. Once the view is created, you can run queries against it like you would a table. SELECT Product, TotalSales, ProductCount ...