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 vote370 views3 answers
Divide by zero error in sql
SQL
0 vote341 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote305 views1 answer
Check if due date is less than todays date sql
SQL
11 votes352 views4 answers
Round in sql
SQL
0 vote406 views1 answer
Acutal month year
SQL
2 votes388 views1 answer
Sql as
SQL
4 votes365 views2 answers
How to insert ip address in mysql using php
SQL
1 vote392 views1 answer
Sql server delete top 1000
SQL
0 vote375 views1 answer
Oracle session statistics
SQL
-1 vote356 views1 answer
Add column alter table default value
SQL