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

4 votes347 views4 answers
What is primary key
SQL
0 vote380 views1 answer
Oracle decode
SQL
1 vote303 views1 answer
Foreign key constraint in ms sql
SQL
0 vote339 views2 answers
Get top 1 row of each group
SQL
0 vote334 views1 answer
Set a default value for a column in sqlite
SQL
0 vote323 views1 answer
Sql counter column
SQL
0 vote320 views1 answer
Codeigniter dbforge add index
SQL
9 votes387 views3 answers
Sql delete where in
SQL
0 vote341 views1 answer
Create table database in psql
SQL
0 vote360 views1 answer
How to install sql in anaconda
SQL