Views in sql

Views are created in order to store your queries as virtual
table. If there are a lot of columns and we don’t want to
use all columns and make the table simpler, we can create a
view and reuse it repeatedly. Actually, view does not store
any data however, it contains the retrieve statements to
provide reusability. We can create view if we use some
queries mostly.
create view EmployeeInfo as
select first_name || last_name as "Full Name"
from employees;

Similar codes

0 vote157 views1 answer
What is top n result in sql
SQL
4 votes147 views3 answers
How to describe a table in sqlite3
SQL
0 vote136 views1 answer
Check if record exists mysql
SQL
3 votes124 views1 answer
Difference sql vs mysql
SQL
0 vote163 views1 answer
Hashpass
SQL
6 votes138 views3 answers
Update with inner join postgres
SQL
2 votes156 views1 answer
Sql server find columns list in tables
SQL
12 votes136 views4 answers
Mysql ifnull
SQL
16 votes170 views6 answers
Python sqlite
SQL
-1 vote152 views2 answers
Mysql get day of week
SQL