Developers can select rows from a View. For example, suppose the database includes a view called “LargeLCD,” in which each row describes a PC monitor which diagonal exceed 19 inches. The view definition might look like this:

C# 8.0 and .NET Core 3.0 – Modern Cross-Platform Development: Build applications with C#, .NET Core, Entity Framework Core, ASP.NET Core, and ML.NET using Visual Studio Code, 4th Edition
ASP.NET Core 3 and Angular 9: Full stack web development with .NET Core 3.1 and Angular 9, 3rd Edition
C# in Depth, 4th Edition

 

SELECT *

FROM monitors

WHERE diagonal > 21

 

Developers can select the expensive monitors merely by selecting the expensive monitors from the LargeLCD view. The resulting SQL might look like this:

 

SELECT *

FROM LargeLCD

WHERE price > 400

 

Similarly, a view can participate in a JOIN operation. For example, developers can find the sales of large monitors merely by joining the sales table to the LargeLCD view. The resulting SQL might look like this:

 

SELECT *

FROM sales

INNER JOIN

LargeLCD

ON sales.model_id

=  LargeLCD.model_id