Show List
Tutorials > SQL > Creating and using views

Creating and using views

In SQL, a view is a virtual table that is based on the result of a SELECT statement. Views can be used to simplify the complexity of a query, to isolate parts of a database for security reasons, or to present data in a way that is customized for specific users or applications.

Here's an example of how to create a view in SQL:

sql
Copy code
CREATE VIEW top_salaries AS
SELECT first_name, last_name, salary
FROM employees
WHERE salary > 100000;

In this example, the CREATE VIEW statement is used to create a new view named top_salaries. The SELECT statement that follows defines the structure and data that the view will contain. In this case, the view will contain the first_name, last_name, and salary columns of all employees whose salaries are greater than $100,000.

Once a view has been created, you can use it in a SELECT statement just like any other table:

sql
Copy code
SELECT *
FROM top_salaries;

In this example, the SELECT statement retrieves all columns and rows from the top_salaries view. The result is a table that contains the first_name, last_name, and salary columns of all employees whose salaries are greater than $100,000.

It's important to note that views are virtual tables and do not store data themselves. Instead, they retrieve data from the underlying tables each time they are used. This means that if the data in the underlying tables changes, the data in the view will change as well.



Next: Using built-in functions

    Leave a Comment

  • captcha text