SQLzoo: CREATE a VIEW.

Execute tidy up code silently

DROP VIEW v_europe

Execute set up code

DROP TABLE cia; 
CREATE TABLE cia(
   name VARCHAR(50) NOT NULL
   ,region VARCHAR(60)
   ,area DECIMAL(10) 		
   ,population DECIMAL(11)	
   ,gdp DECIMAL(14)		
   ,PRIMARY KEY (name)
   );
insert into cia values ('Afghanistan','Asia',652000,25838797,21000000000);
insert into cia values ('Algeria','Africa',2381740,31193917,147600000000);
insert into cia values ('Argentina','South America',2766890,36955182,367000000000);
insert into cia values ('Australia','Oceania',7686850,19169083,416200000000);
insert into cia values ('Bangladesh','Asia',144000,129194224,187000000000);
insert into cia values ('Brazil','South America',8511965,172860370,1130000000000);
insert into cia values ('Burma','Southeast Asia',678500,41734853,59400000000);
insert into cia values ('Canada','North America',9976140,31281092,722300000000);
insert into cia values ('China','Asia',9596960,1261832482,4800000000000);
insert into cia values ('Colombia','South America, Central America and the Caribbean',1138910,39685655,245100000000);
insert into cia values ('Congo, Democratic Republic of the','Africa',2345410,51964999,35700000000);
insert into cia values ('Egypt','Africa',1001450,68359979,200000000000);
insert into cia values ('Ethiopia','Africa',1127127,64117452,33300000000);
insert into cia values ('France','Europe',547030,59329691,1373000000000);
insert into cia values ('Germany','Europe',357021,82797408,1864000000000);
insert into cia values ('India','Asia',3287590,1014003817,1805000000000);
insert into cia values ('Indonesia','Southeast Asia',1919440,224784210,610000000000);
insert into cia values ('Iran','Middle East',1648000,65619636,347600000000);
insert into cia values ('Iraq','Middle East',437072,22675617,59900000000);
insert into cia values ('Italy','Europe',301230,57634327,1212000000000);
insert into cia values ('Japan','Asia',377835,126549976,2950000000000);
insert into cia values ('Kenya','Africa',582650,30339770,45100000000);
insert into cia values ('Korea, North','Asia',120540,21687550,22600000000);
insert into cia values ('Malaysia','Southeast Asia',329750,21793293,229100000000);
insert into cia values ('Mexico','North America',1972550,100349766,865500000000);
insert into cia values ('Morocco','Africa',446550,30122350,108000000000);
insert into cia values ('Nepal','Asia',140800,24702119,27400000000);
insert into cia values ('Nigeria','Africa',923768,123337822,110500000000);
insert into cia values ('Pakistan','Asia',803940,141553775,282000000000);
insert into cia values ('Peru','South America',1280000,27012899,116000000000);
insert into cia values ('Philippines','Southeast Asia',300000,81159644,282000000000);
insert into cia values ('Poland','Europe',312685,38646023,276500000000);
insert into cia values ('Romania','Europe',237500,22411121,87400000000);
insert into cia values ('Russia','Asia',17075200,146001176,620300000000);
insert into cia values ('Saudi Arabia','Middle East',1960582,22023506,191000000000);
insert into cia values ('South Africa','Africa',1219912,43421021,296100000000);
insert into cia values ('Spain','Europe',504782,39996671,677500000000);
insert into cia values ('Sudan','Africa',2505810,35079814,32600000000);
insert into cia values ('Taiwan','Southeast Asia',35980,22191087,357000000000);
insert into cia values ('Tanzania','Africa',945087,35306126,23300000000);
insert into cia values ('Thailand','Southeast Asia',514000,61230874,388700000000);
insert into cia values ('Turkey','Europe',780580,65666677,409400000000);
insert into cia values ('Uganda','Africa',236040,23317560,24200000000);
insert into cia values ('Ukraine','Commonwealth of Independent States',603700,49153027,109500000000);
insert into cia values ('United Kingdom','Europe',244820,59511464,1290000000000);
insert into cia values ('United States','North America',9629091,275562673,9255000000000);
insert into cia values ('Uzbekistan','Commonwealth of Independent States',447400,24755519,59300000000);
insert into cia values ('Venezuela','South America, Central America and the Caribbean',912050,23542649,182800000000);
insert into cia values ('Vietnam','Southeast Asia',329560,78773873,143100000000);

Execute tidy up code silently

DROP VIEW v_europe

Execute set up code

Execute tidy up code silently

DROP TABLE v_europe

Execute set up code

Execute tidy up code silently

DROP VIEW v_europe

Execute set up code

Execute tidy up code silently

DROP VIEW v_europe

Execute set up code

Execute tidy up code silently

DROP VIEW v_europe

Execute set up code

Execute tidy up code silently

DROP VIEW v_europe

Execute set up code

Execute tidy up code silently

DROP VIEW v_europe

Execute set up code

Execute tidy up code silently

DROP VIEW v_europe

Execute set up code

SQLite
A view is a named SELECT statement. In this example we show only European countries, we also show the population in millions. Note how the columns of the table may be named.	Execute tidy up code silently DROP VIEW v_europe Execute set up code DROP TABLE cia; CREATE TABLE cia( name VARCHAR(50) NOT NULL ,region VARCHAR(60) ,area DECIMAL(10) ,population DECIMAL(11) ,gdp DECIMAL(14) ,PRIMARY KEY (name) ); insert into cia values ('Afghanistan','Asia',652000,25838797,21000000000); insert into cia values ('Algeria','Africa',2381740,31193917,147600000000); insert into cia values ('Argentina','South America',2766890,36955182,367000000000); insert into cia values ('Australia','Oceania',7686850,19169083,416200000000); insert into cia values ('Bangladesh','Asia',144000,129194224,187000000000); insert into cia values ('Brazil','South America',8511965,172860370,1130000000000); insert into cia values ('Burma','Southeast Asia',678500,41734853,59400000000); insert into cia values ('Canada','North America',9976140,31281092,722300000000); insert into cia values ('China','Asia',9596960,1261832482,4800000000000); insert into cia values ('Colombia','South America, Central America and the Caribbean',1138910,39685655,245100000000); insert into cia values ('Congo, Democratic Republic of the','Africa',2345410,51964999,35700000000); insert into cia values ('Egypt','Africa',1001450,68359979,200000000000); insert into cia values ('Ethiopia','Africa',1127127,64117452,33300000000); insert into cia values ('France','Europe',547030,59329691,1373000000000); insert into cia values ('Germany','Europe',357021,82797408,1864000000000); insert into cia values ('India','Asia',3287590,1014003817,1805000000000); insert into cia values ('Indonesia','Southeast Asia',1919440,224784210,610000000000); insert into cia values ('Iran','Middle East',1648000,65619636,347600000000); insert into cia values ('Iraq','Middle East',437072,22675617,59900000000); insert into cia values ('Italy','Europe',301230,57634327,1212000000000); insert into cia values ('Japan','Asia',377835,126549976,2950000000000); insert into cia values ('Kenya','Africa',582650,30339770,45100000000); insert into cia values ('Korea, North','Asia',120540,21687550,22600000000); insert into cia values ('Malaysia','Southeast Asia',329750,21793293,229100000000); insert into cia values ('Mexico','North America',1972550,100349766,865500000000); insert into cia values ('Morocco','Africa',446550,30122350,108000000000); insert into cia values ('Nepal','Asia',140800,24702119,27400000000); insert into cia values ('Nigeria','Africa',923768,123337822,110500000000); insert into cia values ('Pakistan','Asia',803940,141553775,282000000000); insert into cia values ('Peru','South America',1280000,27012899,116000000000); insert into cia values ('Philippines','Southeast Asia',300000,81159644,282000000000); insert into cia values ('Poland','Europe',312685,38646023,276500000000); insert into cia values ('Romania','Europe',237500,22411121,87400000000); insert into cia values ('Russia','Asia',17075200,146001176,620300000000); insert into cia values ('Saudi Arabia','Middle East',1960582,22023506,191000000000); insert into cia values ('South Africa','Africa',1219912,43421021,296100000000); insert into cia values ('Spain','Europe',504782,39996671,677500000000); insert into cia values ('Sudan','Africa',2505810,35079814,32600000000); insert into cia values ('Taiwan','Southeast Asia',35980,22191087,357000000000); insert into cia values ('Tanzania','Africa',945087,35306126,23300000000); insert into cia values ('Thailand','Southeast Asia',514000,61230874,388700000000); insert into cia values ('Turkey','Europe',780580,65666677,409400000000); insert into cia values ('Uganda','Africa',236040,23317560,24200000000); insert into cia values ('Ukraine','Commonwealth of Independent States',603700,49153027,109500000000); insert into cia values ('United Kingdom','Europe',244820,59511464,1290000000000); insert into cia values ('United States','North America',9629091,275562673,9255000000000); insert into cia values ('Uzbekistan','Commonwealth of Independent States',447400,24755519,59300000000); insert into cia values ('Venezuela','South America, Central America and the Caribbean',912050,23542649,182800000000); insert into cia values ('Vietnam','Southeast Asia',329560,78773873,143100000000); CREATE VIEW v_europe AS SELECT name, ROUND(population/1000000,0) AS pop FROM cia WHERE region='Europe'; SELECT * FROM v_europe
Specific to SQLite
none

DB2
A view is a named SELECT statement. In this example we show only European countries, we also show the population in millions. Note how the columns of the table may be named.	Execute tidy up code silently DROP VIEW v_europe Execute set up code DROP TABLE cia; CREATE TABLE cia( name VARCHAR(50) NOT NULL ,region VARCHAR(60) ,area DECIMAL(10) ,population DECIMAL(11) ,gdp DECIMAL(14) ,PRIMARY KEY (name) ); insert into cia values ('Afghanistan','Asia',652000,25838797,21000000000); insert into cia values ('Algeria','Africa',2381740,31193917,147600000000); insert into cia values ('Argentina','South America',2766890,36955182,367000000000); insert into cia values ('Australia','Oceania',7686850,19169083,416200000000); insert into cia values ('Bangladesh','Asia',144000,129194224,187000000000); insert into cia values ('Brazil','South America',8511965,172860370,1130000000000); insert into cia values ('Burma','Southeast Asia',678500,41734853,59400000000); insert into cia values ('Canada','North America',9976140,31281092,722300000000); insert into cia values ('China','Asia',9596960,1261832482,4800000000000); insert into cia values ('Colombia','South America, Central America and the Caribbean',1138910,39685655,245100000000); insert into cia values ('Congo, Democratic Republic of the','Africa',2345410,51964999,35700000000); insert into cia values ('Egypt','Africa',1001450,68359979,200000000000); insert into cia values ('Ethiopia','Africa',1127127,64117452,33300000000); insert into cia values ('France','Europe',547030,59329691,1373000000000); insert into cia values ('Germany','Europe',357021,82797408,1864000000000); insert into cia values ('India','Asia',3287590,1014003817,1805000000000); insert into cia values ('Indonesia','Southeast Asia',1919440,224784210,610000000000); insert into cia values ('Iran','Middle East',1648000,65619636,347600000000); insert into cia values ('Iraq','Middle East',437072,22675617,59900000000); insert into cia values ('Italy','Europe',301230,57634327,1212000000000); insert into cia values ('Japan','Asia',377835,126549976,2950000000000); insert into cia values ('Kenya','Africa',582650,30339770,45100000000); insert into cia values ('Korea, North','Asia',120540,21687550,22600000000); insert into cia values ('Malaysia','Southeast Asia',329750,21793293,229100000000); insert into cia values ('Mexico','North America',1972550,100349766,865500000000); insert into cia values ('Morocco','Africa',446550,30122350,108000000000); insert into cia values ('Nepal','Asia',140800,24702119,27400000000); insert into cia values ('Nigeria','Africa',923768,123337822,110500000000); insert into cia values ('Pakistan','Asia',803940,141553775,282000000000); insert into cia values ('Peru','South America',1280000,27012899,116000000000); insert into cia values ('Philippines','Southeast Asia',300000,81159644,282000000000); insert into cia values ('Poland','Europe',312685,38646023,276500000000); insert into cia values ('Romania','Europe',237500,22411121,87400000000); insert into cia values ('Russia','Asia',17075200,146001176,620300000000); insert into cia values ('Saudi Arabia','Middle East',1960582,22023506,191000000000); insert into cia values ('South Africa','Africa',1219912,43421021,296100000000); insert into cia values ('Spain','Europe',504782,39996671,677500000000); insert into cia values ('Sudan','Africa',2505810,35079814,32600000000); insert into cia values ('Taiwan','Southeast Asia',35980,22191087,357000000000); insert into cia values ('Tanzania','Africa',945087,35306126,23300000000); insert into cia values ('Thailand','Southeast Asia',514000,61230874,388700000000); insert into cia values ('Turkey','Europe',780580,65666677,409400000000); insert into cia values ('Uganda','Africa',236040,23317560,24200000000); insert into cia values ('Ukraine','Commonwealth of Independent States',603700,49153027,109500000000); insert into cia values ('United Kingdom','Europe',244820,59511464,1290000000000); insert into cia values ('United States','North America',9629091,275562673,9255000000000); insert into cia values ('Uzbekistan','Commonwealth of Independent States',447400,24755519,59300000000); insert into cia values ('Venezuela','South America, Central America and the Caribbean',912050,23542649,182800000000); insert into cia values ('Vietnam','Southeast Asia',329560,78773873,143100000000); CREATE VIEW v_europe AS SELECT name, ROUND(population/1000000,0) AS pop FROM cia WHERE region='Europe'; SELECT * FROM v_europe
Specific to DB2
none

MS Access
A view is a named SELECT statement. In this example we show only European countries, we also show the population in millions. Note how the columns of the table may be named.	Execute tidy up code silently DROP TABLE v_europe Execute set up code DROP TABLE cia; CREATE TABLE cia( name VARCHAR(50) NOT NULL ,region VARCHAR(60) ,area DECIMAL(10) ,population DECIMAL(11) ,gdp DECIMAL(14) ,PRIMARY KEY (name) ); insert into cia values ('Afghanistan','Asia',652000,25838797,21000000000); insert into cia values ('Algeria','Africa',2381740,31193917,147600000000); insert into cia values ('Argentina','South America',2766890,36955182,367000000000); insert into cia values ('Australia','Oceania',7686850,19169083,416200000000); insert into cia values ('Bangladesh','Asia',144000,129194224,187000000000); insert into cia values ('Brazil','South America',8511965,172860370,1130000000000); insert into cia values ('Burma','Southeast Asia',678500,41734853,59400000000); insert into cia values ('Canada','North America',9976140,31281092,722300000000); insert into cia values ('China','Asia',9596960,1261832482,4800000000000); insert into cia values ('Colombia','South America, Central America and the Caribbean',1138910,39685655,245100000000); insert into cia values ('Congo, Democratic Republic of the','Africa',2345410,51964999,35700000000); insert into cia values ('Egypt','Africa',1001450,68359979,200000000000); insert into cia values ('Ethiopia','Africa',1127127,64117452,33300000000); insert into cia values ('France','Europe',547030,59329691,1373000000000); insert into cia values ('Germany','Europe',357021,82797408,1864000000000); insert into cia values ('India','Asia',3287590,1014003817,1805000000000); insert into cia values ('Indonesia','Southeast Asia',1919440,224784210,610000000000); insert into cia values ('Iran','Middle East',1648000,65619636,347600000000); insert into cia values ('Iraq','Middle East',437072,22675617,59900000000); insert into cia values ('Italy','Europe',301230,57634327,1212000000000); insert into cia values ('Japan','Asia',377835,126549976,2950000000000); insert into cia values ('Kenya','Africa',582650,30339770,45100000000); insert into cia values ('Korea, North','Asia',120540,21687550,22600000000); insert into cia values ('Malaysia','Southeast Asia',329750,21793293,229100000000); insert into cia values ('Mexico','North America',1972550,100349766,865500000000); insert into cia values ('Morocco','Africa',446550,30122350,108000000000); insert into cia values ('Nepal','Asia',140800,24702119,27400000000); insert into cia values ('Nigeria','Africa',923768,123337822,110500000000); insert into cia values ('Pakistan','Asia',803940,141553775,282000000000); insert into cia values ('Peru','South America',1280000,27012899,116000000000); insert into cia values ('Philippines','Southeast Asia',300000,81159644,282000000000); insert into cia values ('Poland','Europe',312685,38646023,276500000000); insert into cia values ('Romania','Europe',237500,22411121,87400000000); insert into cia values ('Russia','Asia',17075200,146001176,620300000000); insert into cia values ('Saudi Arabia','Middle East',1960582,22023506,191000000000); insert into cia values ('South Africa','Africa',1219912,43421021,296100000000); insert into cia values ('Spain','Europe',504782,39996671,677500000000); insert into cia values ('Sudan','Africa',2505810,35079814,32600000000); insert into cia values ('Taiwan','Southeast Asia',35980,22191087,357000000000); insert into cia values ('Tanzania','Africa',945087,35306126,23300000000); insert into cia values ('Thailand','Southeast Asia',514000,61230874,388700000000); insert into cia values ('Turkey','Europe',780580,65666677,409400000000); insert into cia values ('Uganda','Africa',236040,23317560,24200000000); insert into cia values ('Ukraine','Commonwealth of Independent States',603700,49153027,109500000000); insert into cia values ('United Kingdom','Europe',244820,59511464,1290000000000); insert into cia values ('United States','North America',9629091,275562673,9255000000000); insert into cia values ('Uzbekistan','Commonwealth of Independent States',447400,24755519,59300000000); insert into cia values ('Venezuela','South America, Central America and the Caribbean',912050,23542649,182800000000); insert into cia values ('Vietnam','Southeast Asia',329560,78773873,143100000000); CREATE VIEW v_europe AS SELECT name, ROUND(population/1000000,0) AS pop FROM cia WHERE region='Europe'; SELECT * FROM v_europe
Specific to MS Access
A view is called a query on planet Microsoft Office. Use DROP TABLE to remove a view.

PostgreSQL
A view is a named SELECT statement. In this example we show only European countries, we also show the population in millions. Note how the columns of the table may be named.	Execute tidy up code silently DROP VIEW v_europe Execute set up code DROP TABLE cia; CREATE TABLE cia( name VARCHAR(50) NOT NULL ,region VARCHAR(60) ,area DECIMAL(10) ,population DECIMAL(11) ,gdp DECIMAL(14) ,PRIMARY KEY (name) ); insert into cia values ('Afghanistan','Asia',652000,25838797,21000000000); insert into cia values ('Algeria','Africa',2381740,31193917,147600000000); insert into cia values ('Argentina','South America',2766890,36955182,367000000000); insert into cia values ('Australia','Oceania',7686850,19169083,416200000000); insert into cia values ('Bangladesh','Asia',144000,129194224,187000000000); insert into cia values ('Brazil','South America',8511965,172860370,1130000000000); insert into cia values ('Burma','Southeast Asia',678500,41734853,59400000000); insert into cia values ('Canada','North America',9976140,31281092,722300000000); insert into cia values ('China','Asia',9596960,1261832482,4800000000000); insert into cia values ('Colombia','South America, Central America and the Caribbean',1138910,39685655,245100000000); insert into cia values ('Congo, Democratic Republic of the','Africa',2345410,51964999,35700000000); insert into cia values ('Egypt','Africa',1001450,68359979,200000000000); insert into cia values ('Ethiopia','Africa',1127127,64117452,33300000000); insert into cia values ('France','Europe',547030,59329691,1373000000000); insert into cia values ('Germany','Europe',357021,82797408,1864000000000); insert into cia values ('India','Asia',3287590,1014003817,1805000000000); insert into cia values ('Indonesia','Southeast Asia',1919440,224784210,610000000000); insert into cia values ('Iran','Middle East',1648000,65619636,347600000000); insert into cia values ('Iraq','Middle East',437072,22675617,59900000000); insert into cia values ('Italy','Europe',301230,57634327,1212000000000); insert into cia values ('Japan','Asia',377835,126549976,2950000000000); insert into cia values ('Kenya','Africa',582650,30339770,45100000000); insert into cia values ('Korea, North','Asia',120540,21687550,22600000000); insert into cia values ('Malaysia','Southeast Asia',329750,21793293,229100000000); insert into cia values ('Mexico','North America',1972550,100349766,865500000000); insert into cia values ('Morocco','Africa',446550,30122350,108000000000); insert into cia values ('Nepal','Asia',140800,24702119,27400000000); insert into cia values ('Nigeria','Africa',923768,123337822,110500000000); insert into cia values ('Pakistan','Asia',803940,141553775,282000000000); insert into cia values ('Peru','South America',1280000,27012899,116000000000); insert into cia values ('Philippines','Southeast Asia',300000,81159644,282000000000); insert into cia values ('Poland','Europe',312685,38646023,276500000000); insert into cia values ('Romania','Europe',237500,22411121,87400000000); insert into cia values ('Russia','Asia',17075200,146001176,620300000000); insert into cia values ('Saudi Arabia','Middle East',1960582,22023506,191000000000); insert into cia values ('South Africa','Africa',1219912,43421021,296100000000); insert into cia values ('Spain','Europe',504782,39996671,677500000000); insert into cia values ('Sudan','Africa',2505810,35079814,32600000000); insert into cia values ('Taiwan','Southeast Asia',35980,22191087,357000000000); insert into cia values ('Tanzania','Africa',945087,35306126,23300000000); insert into cia values ('Thailand','Southeast Asia',514000,61230874,388700000000); insert into cia values ('Turkey','Europe',780580,65666677,409400000000); insert into cia values ('Uganda','Africa',236040,23317560,24200000000); insert into cia values ('Ukraine','Commonwealth of Independent States',603700,49153027,109500000000); insert into cia values ('United Kingdom','Europe',244820,59511464,1290000000000); insert into cia values ('United States','North America',9629091,275562673,9255000000000); insert into cia values ('Uzbekistan','Commonwealth of Independent States',447400,24755519,59300000000); insert into cia values ('Venezuela','South America, Central America and the Caribbean',912050,23542649,182800000000); insert into cia values ('Vietnam','Southeast Asia',329560,78773873,143100000000); CREATE VIEW v_europe AS SELECT name, ROUND(population/1000000,0) AS pop FROM cia WHERE region='Europe'; SELECT * FROM v_europe
Specific to PostgreSQL
none

Oracle
A view is a named SELECT statement. In this example we show only European countries, we also show the population in millions. Note how the columns of the table may be named.	Execute tidy up code silently DROP VIEW v_europe Execute set up code DROP TABLE cia; CREATE TABLE cia( name VARCHAR(50) NOT NULL ,region VARCHAR(60) ,area DECIMAL(10) ,population DECIMAL(11) ,gdp DECIMAL(14) ,PRIMARY KEY (name) ); insert into cia values ('Afghanistan','Asia',652000,25838797,21000000000); insert into cia values ('Algeria','Africa',2381740,31193917,147600000000); insert into cia values ('Argentina','South America',2766890,36955182,367000000000); insert into cia values ('Australia','Oceania',7686850,19169083,416200000000); insert into cia values ('Bangladesh','Asia',144000,129194224,187000000000); insert into cia values ('Brazil','South America',8511965,172860370,1130000000000); insert into cia values ('Burma','Southeast Asia',678500,41734853,59400000000); insert into cia values ('Canada','North America',9976140,31281092,722300000000); insert into cia values ('China','Asia',9596960,1261832482,4800000000000); insert into cia values ('Colombia','South America, Central America and the Caribbean',1138910,39685655,245100000000); insert into cia values ('Congo, Democratic Republic of the','Africa',2345410,51964999,35700000000); insert into cia values ('Egypt','Africa',1001450,68359979,200000000000); insert into cia values ('Ethiopia','Africa',1127127,64117452,33300000000); insert into cia values ('France','Europe',547030,59329691,1373000000000); insert into cia values ('Germany','Europe',357021,82797408,1864000000000); insert into cia values ('India','Asia',3287590,1014003817,1805000000000); insert into cia values ('Indonesia','Southeast Asia',1919440,224784210,610000000000); insert into cia values ('Iran','Middle East',1648000,65619636,347600000000); insert into cia values ('Iraq','Middle East',437072,22675617,59900000000); insert into cia values ('Italy','Europe',301230,57634327,1212000000000); insert into cia values ('Japan','Asia',377835,126549976,2950000000000); insert into cia values ('Kenya','Africa',582650,30339770,45100000000); insert into cia values ('Korea, North','Asia',120540,21687550,22600000000); insert into cia values ('Malaysia','Southeast Asia',329750,21793293,229100000000); insert into cia values ('Mexico','North America',1972550,100349766,865500000000); insert into cia values ('Morocco','Africa',446550,30122350,108000000000); insert into cia values ('Nepal','Asia',140800,24702119,27400000000); insert into cia values ('Nigeria','Africa',923768,123337822,110500000000); insert into cia values ('Pakistan','Asia',803940,141553775,282000000000); insert into cia values ('Peru','South America',1280000,27012899,116000000000); insert into cia values ('Philippines','Southeast Asia',300000,81159644,282000000000); insert into cia values ('Poland','Europe',312685,38646023,276500000000); insert into cia values ('Romania','Europe',237500,22411121,87400000000); insert into cia values ('Russia','Asia',17075200,146001176,620300000000); insert into cia values ('Saudi Arabia','Middle East',1960582,22023506,191000000000); insert into cia values ('South Africa','Africa',1219912,43421021,296100000000); insert into cia values ('Spain','Europe',504782,39996671,677500000000); insert into cia values ('Sudan','Africa',2505810,35079814,32600000000); insert into cia values ('Taiwan','Southeast Asia',35980,22191087,357000000000); insert into cia values ('Tanzania','Africa',945087,35306126,23300000000); insert into cia values ('Thailand','Southeast Asia',514000,61230874,388700000000); insert into cia values ('Turkey','Europe',780580,65666677,409400000000); insert into cia values ('Uganda','Africa',236040,23317560,24200000000); insert into cia values ('Ukraine','Commonwealth of Independent States',603700,49153027,109500000000); insert into cia values ('United Kingdom','Europe',244820,59511464,1290000000000); insert into cia values ('United States','North America',9629091,275562673,9255000000000); insert into cia values ('Uzbekistan','Commonwealth of Independent States',447400,24755519,59300000000); insert into cia values ('Venezuela','South America, Central America and the Caribbean',912050,23542649,182800000000); insert into cia values ('Vietnam','Southeast Asia',329560,78773873,143100000000); CREATE VIEW v_europe AS SELECT name, ROUND(population/1000000,0) AS pop FROM cia WHERE region='Europe'; SELECT * FROM v_europe
Specific to Oracle
none

MS SQL Server
A view is a named SELECT statement. In this example we show only European countries, we also show the population in millions. Note how the columns of the table may be named.	Execute tidy up code silently DROP VIEW v_europe Execute set up code DROP TABLE cia; CREATE TABLE cia( name VARCHAR(50) NOT NULL ,region VARCHAR(60) ,area DECIMAL(10) ,population DECIMAL(11) ,gdp DECIMAL(14) ,PRIMARY KEY (name) ); insert into cia values ('Afghanistan','Asia',652000,25838797,21000000000); insert into cia values ('Algeria','Africa',2381740,31193917,147600000000); insert into cia values ('Argentina','South America',2766890,36955182,367000000000); insert into cia values ('Australia','Oceania',7686850,19169083,416200000000); insert into cia values ('Bangladesh','Asia',144000,129194224,187000000000); insert into cia values ('Brazil','South America',8511965,172860370,1130000000000); insert into cia values ('Burma','Southeast Asia',678500,41734853,59400000000); insert into cia values ('Canada','North America',9976140,31281092,722300000000); insert into cia values ('China','Asia',9596960,1261832482,4800000000000); insert into cia values ('Colombia','South America, Central America and the Caribbean',1138910,39685655,245100000000); insert into cia values ('Congo, Democratic Republic of the','Africa',2345410,51964999,35700000000); insert into cia values ('Egypt','Africa',1001450,68359979,200000000000); insert into cia values ('Ethiopia','Africa',1127127,64117452,33300000000); insert into cia values ('France','Europe',547030,59329691,1373000000000); insert into cia values ('Germany','Europe',357021,82797408,1864000000000); insert into cia values ('India','Asia',3287590,1014003817,1805000000000); insert into cia values ('Indonesia','Southeast Asia',1919440,224784210,610000000000); insert into cia values ('Iran','Middle East',1648000,65619636,347600000000); insert into cia values ('Iraq','Middle East',437072,22675617,59900000000); insert into cia values ('Italy','Europe',301230,57634327,1212000000000); insert into cia values ('Japan','Asia',377835,126549976,2950000000000); insert into cia values ('Kenya','Africa',582650,30339770,45100000000); insert into cia values ('Korea, North','Asia',120540,21687550,22600000000); insert into cia values ('Malaysia','Southeast Asia',329750,21793293,229100000000); insert into cia values ('Mexico','North America',1972550,100349766,865500000000); insert into cia values ('Morocco','Africa',446550,30122350,108000000000); insert into cia values ('Nepal','Asia',140800,24702119,27400000000); insert into cia values ('Nigeria','Africa',923768,123337822,110500000000); insert into cia values ('Pakistan','Asia',803940,141553775,282000000000); insert into cia values ('Peru','South America',1280000,27012899,116000000000); insert into cia values ('Philippines','Southeast Asia',300000,81159644,282000000000); insert into cia values ('Poland','Europe',312685,38646023,276500000000); insert into cia values ('Romania','Europe',237500,22411121,87400000000); insert into cia values ('Russia','Asia',17075200,146001176,620300000000); insert into cia values ('Saudi Arabia','Middle East',1960582,22023506,191000000000); insert into cia values ('South Africa','Africa',1219912,43421021,296100000000); insert into cia values ('Spain','Europe',504782,39996671,677500000000); insert into cia values ('Sudan','Africa',2505810,35079814,32600000000); insert into cia values ('Taiwan','Southeast Asia',35980,22191087,357000000000); insert into cia values ('Tanzania','Africa',945087,35306126,23300000000); insert into cia values ('Thailand','Southeast Asia',514000,61230874,388700000000); insert into cia values ('Turkey','Europe',780580,65666677,409400000000); insert into cia values ('Uganda','Africa',236040,23317560,24200000000); insert into cia values ('Ukraine','Commonwealth of Independent States',603700,49153027,109500000000); insert into cia values ('United Kingdom','Europe',244820,59511464,1290000000000); insert into cia values ('United States','North America',9629091,275562673,9255000000000); insert into cia values ('Uzbekistan','Commonwealth of Independent States',447400,24755519,59300000000); insert into cia values ('Venezuela','South America, Central America and the Caribbean',912050,23542649,182800000000); insert into cia values ('Vietnam','Southeast Asia',329560,78773873,143100000000); CREATE VIEW v_europe AS SELECT name, ROUND(population/1000000,0) AS pop FROM cia WHERE region='Europe'; SELECT * FROM v_europe
Specific to MS SQL Server
none

MySQL
A view is a named SELECT statement. In this example we show only European countries, we also show the population in millions. Note how the columns of the table may be named.	Execute tidy up code silently DROP VIEW v_europe Execute set up code DROP TABLE cia; CREATE TABLE cia( name VARCHAR(50) NOT NULL ,region VARCHAR(60) ,area DECIMAL(10) ,population DECIMAL(11) ,gdp DECIMAL(14) ,PRIMARY KEY (name) ); insert into cia values ('Afghanistan','Asia',652000,25838797,21000000000); insert into cia values ('Algeria','Africa',2381740,31193917,147600000000); insert into cia values ('Argentina','South America',2766890,36955182,367000000000); insert into cia values ('Australia','Oceania',7686850,19169083,416200000000); insert into cia values ('Bangladesh','Asia',144000,129194224,187000000000); insert into cia values ('Brazil','South America',8511965,172860370,1130000000000); insert into cia values ('Burma','Southeast Asia',678500,41734853,59400000000); insert into cia values ('Canada','North America',9976140,31281092,722300000000); insert into cia values ('China','Asia',9596960,1261832482,4800000000000); insert into cia values ('Colombia','South America, Central America and the Caribbean',1138910,39685655,245100000000); insert into cia values ('Congo, Democratic Republic of the','Africa',2345410,51964999,35700000000); insert into cia values ('Egypt','Africa',1001450,68359979,200000000000); insert into cia values ('Ethiopia','Africa',1127127,64117452,33300000000); insert into cia values ('France','Europe',547030,59329691,1373000000000); insert into cia values ('Germany','Europe',357021,82797408,1864000000000); insert into cia values ('India','Asia',3287590,1014003817,1805000000000); insert into cia values ('Indonesia','Southeast Asia',1919440,224784210,610000000000); insert into cia values ('Iran','Middle East',1648000,65619636,347600000000); insert into cia values ('Iraq','Middle East',437072,22675617,59900000000); insert into cia values ('Italy','Europe',301230,57634327,1212000000000); insert into cia values ('Japan','Asia',377835,126549976,2950000000000); insert into cia values ('Kenya','Africa',582650,30339770,45100000000); insert into cia values ('Korea, North','Asia',120540,21687550,22600000000); insert into cia values ('Malaysia','Southeast Asia',329750,21793293,229100000000); insert into cia values ('Mexico','North America',1972550,100349766,865500000000); insert into cia values ('Morocco','Africa',446550,30122350,108000000000); insert into cia values ('Nepal','Asia',140800,24702119,27400000000); insert into cia values ('Nigeria','Africa',923768,123337822,110500000000); insert into cia values ('Pakistan','Asia',803940,141553775,282000000000); insert into cia values ('Peru','South America',1280000,27012899,116000000000); insert into cia values ('Philippines','Southeast Asia',300000,81159644,282000000000); insert into cia values ('Poland','Europe',312685,38646023,276500000000); insert into cia values ('Romania','Europe',237500,22411121,87400000000); insert into cia values ('Russia','Asia',17075200,146001176,620300000000); insert into cia values ('Saudi Arabia','Middle East',1960582,22023506,191000000000); insert into cia values ('South Africa','Africa',1219912,43421021,296100000000); insert into cia values ('Spain','Europe',504782,39996671,677500000000); insert into cia values ('Sudan','Africa',2505810,35079814,32600000000); insert into cia values ('Taiwan','Southeast Asia',35980,22191087,357000000000); insert into cia values ('Tanzania','Africa',945087,35306126,23300000000); insert into cia values ('Thailand','Southeast Asia',514000,61230874,388700000000); insert into cia values ('Turkey','Europe',780580,65666677,409400000000); insert into cia values ('Uganda','Africa',236040,23317560,24200000000); insert into cia values ('Ukraine','Commonwealth of Independent States',603700,49153027,109500000000); insert into cia values ('United Kingdom','Europe',244820,59511464,1290000000000); insert into cia values ('United States','North America',9629091,275562673,9255000000000); insert into cia values ('Uzbekistan','Commonwealth of Independent States',447400,24755519,59300000000); insert into cia values ('Venezuela','South America, Central America and the Caribbean',912050,23542649,182800000000); insert into cia values ('Vietnam','Southeast Asia',329560,78773873,143100000000); Sorry - not implemented.
Specific to MySQL
MySQL does not currently support views. However they do have a plan: implementation

Sybase
A view is a named SELECT statement. In this example we show only European countries, we also show the population in millions. Note how the columns of the table may be named.	Execute tidy up code silently DROP VIEW v_europe Execute set up code DROP TABLE cia; CREATE TABLE cia( name VARCHAR(50) NOT NULL ,region VARCHAR(60) ,area DECIMAL(10) ,population DECIMAL(11) ,gdp DECIMAL(14) ,PRIMARY KEY (name) ); insert into cia values ('Afghanistan','Asia',652000,25838797,21000000000); insert into cia values ('Algeria','Africa',2381740,31193917,147600000000); insert into cia values ('Argentina','South America',2766890,36955182,367000000000); insert into cia values ('Australia','Oceania',7686850,19169083,416200000000); insert into cia values ('Bangladesh','Asia',144000,129194224,187000000000); insert into cia values ('Brazil','South America',8511965,172860370,1130000000000); insert into cia values ('Burma','Southeast Asia',678500,41734853,59400000000); insert into cia values ('Canada','North America',9976140,31281092,722300000000); insert into cia values ('China','Asia',9596960,1261832482,4800000000000); insert into cia values ('Colombia','South America, Central America and the Caribbean',1138910,39685655,245100000000); insert into cia values ('Congo, Democratic Republic of the','Africa',2345410,51964999,35700000000); insert into cia values ('Egypt','Africa',1001450,68359979,200000000000); insert into cia values ('Ethiopia','Africa',1127127,64117452,33300000000); insert into cia values ('France','Europe',547030,59329691,1373000000000); insert into cia values ('Germany','Europe',357021,82797408,1864000000000); insert into cia values ('India','Asia',3287590,1014003817,1805000000000); insert into cia values ('Indonesia','Southeast Asia',1919440,224784210,610000000000); insert into cia values ('Iran','Middle East',1648000,65619636,347600000000); insert into cia values ('Iraq','Middle East',437072,22675617,59900000000); insert into cia values ('Italy','Europe',301230,57634327,1212000000000); insert into cia values ('Japan','Asia',377835,126549976,2950000000000); insert into cia values ('Kenya','Africa',582650,30339770,45100000000); insert into cia values ('Korea, North','Asia',120540,21687550,22600000000); insert into cia values ('Malaysia','Southeast Asia',329750,21793293,229100000000); insert into cia values ('Mexico','North America',1972550,100349766,865500000000); insert into cia values ('Morocco','Africa',446550,30122350,108000000000); insert into cia values ('Nepal','Asia',140800,24702119,27400000000); insert into cia values ('Nigeria','Africa',923768,123337822,110500000000); insert into cia values ('Pakistan','Asia',803940,141553775,282000000000); insert into cia values ('Peru','South America',1280000,27012899,116000000000); insert into cia values ('Philippines','Southeast Asia',300000,81159644,282000000000); insert into cia values ('Poland','Europe',312685,38646023,276500000000); insert into cia values ('Romania','Europe',237500,22411121,87400000000); insert into cia values ('Russia','Asia',17075200,146001176,620300000000); insert into cia values ('Saudi Arabia','Middle East',1960582,22023506,191000000000); insert into cia values ('South Africa','Africa',1219912,43421021,296100000000); insert into cia values ('Spain','Europe',504782,39996671,677500000000); insert into cia values ('Sudan','Africa',2505810,35079814,32600000000); insert into cia values ('Taiwan','Southeast Asia',35980,22191087,357000000000); insert into cia values ('Tanzania','Africa',945087,35306126,23300000000); insert into cia values ('Thailand','Southeast Asia',514000,61230874,388700000000); insert into cia values ('Turkey','Europe',780580,65666677,409400000000); insert into cia values ('Uganda','Africa',236040,23317560,24200000000); insert into cia values ('Ukraine','Commonwealth of Independent States',603700,49153027,109500000000); insert into cia values ('United Kingdom','Europe',244820,59511464,1290000000000); insert into cia values ('United States','North America',9629091,275562673,9255000000000); insert into cia values ('Uzbekistan','Commonwealth of Independent States',447400,24755519,59300000000); insert into cia values ('Venezuela','South America, Central America and the Caribbean',912050,23542649,182800000000); insert into cia values ('Vietnam','Southeast Asia',329560,78773873,143100000000); CREATE VIEW v_europe AS SELECT name, ROUND(population/1000000,0) AS pop FROM cia WHERE region='Europe'; SELECT * FROM v_europe
Specific to Sybase
none

Mimer SQL
A view is a named SELECT statement. In this example we show only European countries, we also show the population in millions. Note how the columns of the table may be named.	Execute tidy up code silently DROP VIEW v_europe Execute set up code DROP TABLE cia; CREATE TABLE cia( name VARCHAR(50) NOT NULL ,region VARCHAR(60) ,area DECIMAL(10) ,population DECIMAL(11) ,gdp DECIMAL(14) ,PRIMARY KEY (name) ); insert into cia values ('Afghanistan','Asia',652000,25838797,21000000000); insert into cia values ('Algeria','Africa',2381740,31193917,147600000000); insert into cia values ('Argentina','South America',2766890,36955182,367000000000); insert into cia values ('Australia','Oceania',7686850,19169083,416200000000); insert into cia values ('Bangladesh','Asia',144000,129194224,187000000000); insert into cia values ('Brazil','South America',8511965,172860370,1130000000000); insert into cia values ('Burma','Southeast Asia',678500,41734853,59400000000); insert into cia values ('Canada','North America',9976140,31281092,722300000000); insert into cia values ('China','Asia',9596960,1261832482,4800000000000); insert into cia values ('Colombia','South America, Central America and the Caribbean',1138910,39685655,245100000000); insert into cia values ('Congo, Democratic Republic of the','Africa',2345410,51964999,35700000000); insert into cia values ('Egypt','Africa',1001450,68359979,200000000000); insert into cia values ('Ethiopia','Africa',1127127,64117452,33300000000); insert into cia values ('France','Europe',547030,59329691,1373000000000); insert into cia values ('Germany','Europe',357021,82797408,1864000000000); insert into cia values ('India','Asia',3287590,1014003817,1805000000000); insert into cia values ('Indonesia','Southeast Asia',1919440,224784210,610000000000); insert into cia values ('Iran','Middle East',1648000,65619636,347600000000); insert into cia values ('Iraq','Middle East',437072,22675617,59900000000); insert into cia values ('Italy','Europe',301230,57634327,1212000000000); insert into cia values ('Japan','Asia',377835,126549976,2950000000000); insert into cia values ('Kenya','Africa',582650,30339770,45100000000); insert into cia values ('Korea, North','Asia',120540,21687550,22600000000); insert into cia values ('Malaysia','Southeast Asia',329750,21793293,229100000000); insert into cia values ('Mexico','North America',1972550,100349766,865500000000); insert into cia values ('Morocco','Africa',446550,30122350,108000000000); insert into cia values ('Nepal','Asia',140800,24702119,27400000000); insert into cia values ('Nigeria','Africa',923768,123337822,110500000000); insert into cia values ('Pakistan','Asia',803940,141553775,282000000000); insert into cia values ('Peru','South America',1280000,27012899,116000000000); insert into cia values ('Philippines','Southeast Asia',300000,81159644,282000000000); insert into cia values ('Poland','Europe',312685,38646023,276500000000); insert into cia values ('Romania','Europe',237500,22411121,87400000000); insert into cia values ('Russia','Asia',17075200,146001176,620300000000); insert into cia values ('Saudi Arabia','Middle East',1960582,22023506,191000000000); insert into cia values ('South Africa','Africa',1219912,43421021,296100000000); insert into cia values ('Spain','Europe',504782,39996671,677500000000); insert into cia values ('Sudan','Africa',2505810,35079814,32600000000); insert into cia values ('Taiwan','Southeast Asia',35980,22191087,357000000000); insert into cia values ('Tanzania','Africa',945087,35306126,23300000000); insert into cia values ('Thailand','Southeast Asia',514000,61230874,388700000000); insert into cia values ('Turkey','Europe',780580,65666677,409400000000); insert into cia values ('Uganda','Africa',236040,23317560,24200000000); insert into cia values ('Ukraine','Commonwealth of Independent States',603700,49153027,109500000000); insert into cia values ('United Kingdom','Europe',244820,59511464,1290000000000); insert into cia values ('United States','North America',9629091,275562673,9255000000000); insert into cia values ('Uzbekistan','Commonwealth of Independent States',447400,24755519,59300000000); insert into cia values ('Venezuela','South America, Central America and the Caribbean',912050,23542649,182800000000); insert into cia values ('Vietnam','Southeast Asia',329560,78773873,143100000000); CREATE VIEW v_europe AS SELECT name, ROUND(population/1000000,0) AS pop FROM cia WHERE region='Europe'; SELECT * FROM v_europe
Specific to Mimer SQL
none

Eine Einführung in SQL

CREATE a VIEW.

Eine Einführung in

SQL