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 vote321 views1 answer
How to insert same table data using mysql query
SQL
0 vote362 views1 answer
Sql query tags
SQL
5 votes347 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote360 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote362 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote357 views1 answer
Mysql join column order By and group By
SQL
0 vote406 views1 answer
Mysql backup query
SQL
-1 vote369 views3 answers
My sql alter table
SQL
2 votes391 views1 answer
Oracle insert or update
SQL
0 vote342 views1 answer
Trigger value from maltiple table to single table mysql
SQL