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 ggl_links

WHERE url LIKE '%glo%'

GO

SELECT tag, counts, url, created

FROM myLinks ORDER BY counts DESC

GO

tag counts url created

DBA 972 rendc.org 2007-05-19

SQA 728 rendc.org/html 2007-05-19

DEV 120 rendc.org/sql 2006-04-30