SELECT

The SELECT statement is used to query views.

Syntax:

SELECT columnName FROM view_name 

Example 1:

SELECT * FROM example_view_name 

Example 2:

SELECT customertype, SUM(quantity) as unitsSold, SUM(sales) as sales 
FROM example_view_name v 
INNER JOIN nw_customers c on v.customerid=c.customerid 
GROUP BY customertype 
ORDER BY unitsSold DESC, customertype 

For limitations in querying views, see Limitations and restrictions for Views.