How to Create a View using Data from Another View?
Submitted by: AdministratorCan You Create a View with Data from Another View? The answer is yes. A view can be used as a table to build other views. The tutorial exercise below shows you how to create a view using data from another view:
<pre>USE AdventureWorksLT;
GO
CREATE VIEW SalesOrderTop AS
SELECT SalesOrderNumber, TotalDue, CompanyName
FROM SalesOrderView
WHERE TotalDue > 10000.0
GO
SELECT TOP 10 * FROM SalesOrderTop;
GO
SalesOrderNumber TotalDue CompanyName
---------------- ----------- ------------------------------
SO71780 42452.6519 Nearby Cycle Shop
SO71782 43962.7901 Professional Sales and Service
SO71783 92663.5609 Eastside Department Store
SO71784 119960.824 Action Bicycle Specialists
SO71796 63686.2708 Extreme Riding Supplies
SO71797 86222.8072 Riding Cycles
SO71832 39531.6085 Closest Bicycle Store
SO71845 45992.3665 Trailblazing Sports
SO71858 15275.1977 Thrilling Bike Tours
SO71897 14017.9083 Paints and Solvents Company</pre>
Submitted by: Administrator
<pre>USE AdventureWorksLT;
GO
CREATE VIEW SalesOrderTop AS
SELECT SalesOrderNumber, TotalDue, CompanyName
FROM SalesOrderView
WHERE TotalDue > 10000.0
GO
SELECT TOP 10 * FROM SalesOrderTop;
GO
SalesOrderNumber TotalDue CompanyName
---------------- ----------- ------------------------------
SO71780 42452.6519 Nearby Cycle Shop
SO71782 43962.7901 Professional Sales and Service
SO71783 92663.5609 Eastside Department Store
SO71784 119960.824 Action Bicycle Specialists
SO71796 63686.2708 Extreme Riding Supplies
SO71797 86222.8072 Riding Cycles
SO71832 39531.6085 Closest Bicycle Store
SO71845 45992.3665 Trailblazing Sports
SO71858 15275.1977 Thrilling Bike Tours
SO71897 14017.9083 Paints and Solvents Company</pre>
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
☺ | How To Convert Binary Strings into Integers in MS SQL Server? |
☺ | What Happens If NULL Values Are Involved in Bitwise Operations? |
☺ | What Happens If You Insert a Duplicate Key for the Primary Key Column in MS SQL Server? |
☺ | What Happens If Strings Are Casted into Wrong Code Pages in MS SQL Server? |
☺ | How To Use Subqueries with the IN Operators in MS SQL Server? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Sybase Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |