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

-1 vote153 views1 answer
Difference berween database and data base management system
SQL
17 votes109 views6 answers
Sql select distinct
SQL
1 vote113 views1 answer
Sql to mongodb query converter
SQL
2 votes101 views4 answers
Duplicate record mysql
SQL
0 vote64 views1 answer
Oracle function select into
SQL
1 vote107 views1 answer
Postgresql filter on
SQL
0 vote111 views1 answer
ALV GRID events
SQL
1 vote105 views1 answer
Mysql login console
SQL
0 vote105 views1 answer
Create bdd mysql
SQL
1 vote94 views1 answer
Avg mysql
SQL