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 vote139 views1 answer
Sql delete dastabase
SQL
0 vote142 views1 answer
How to add mysql to path on termin after installation
SQL
17 votes127 views4 answers
Set mysql Password
SQL
0 vote130 views1 answer
Left join in codeigniter query builder
SQL
2 votes160 views1 answer
Datefromparts mssql
SQL
0 vote126 views1 answer
Postgres float to int
SQL
12 votes119 views3 answers
Install sqlite driver ubuntu
SQL
1 vote120 views1 answer
Importance of comment in mysql
SQL
16 votes121 views1 answer
Sqlserver add column to table
SQL
0 vote135 views3 answers
How to assign custom id in mysql
SQL