Using SELECT Statements on Views in SQL Server


Can SELECT Statements Be Used on Views in SQL Server?



Select (query) statements can be used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view:

CREATE VIEW myLinks AS SELECT * FROM fyi_links 
   WHERE url LIKE '%fyi%'

SELECT tag, counts, url, created 
   FROM myLinks ORDER BY counts DESC
tag     counts  url                     created
DBA     972       2007-05-19
SQA     728       2007-05-19
DEV     120       2006-04-30


Filtering Out Duplications in the Returning Rows in SQL Server

Counting Rows with the COUNT(*) Function in SQL Server

Using SELECT Statements and GROUP BY Clauses in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-10-26, 1931🔥, 0💬