CREATE TABLE customers ( id INTEGER PRIMARY KEY, FirstName TEXT NOT NULL, LastName TEXT NOT NULL, PhoneNumber TEXT NOT NULL, Extension TEXT

); -- insert some values INSERT INTO customers VALUES (1, 'Hxxx', 'Rxx', '1', NULL); INSERT INTO customers VALUES (2, 'Lxx', 'Fxxx', '2', NULL); INSERT INTO customers VALUES (3, 'Micxx', 'Sax', '3', '12'); INSERT INTO customers VALUES (4, 'Minxxx', 'H..', '4', '77'); INSERT INTO customers VALUES (5, 'Sxx', 'Stxxx', '5', NULL); -- fetch some values --SELECT * FROM customers; --SELECT * FROM customers where Extension is not NULL; SELECT * FROM customers where Extension is not NULL order by LastName;

create view: SQL online實作練習

• • create a table CREATE TABLE students ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, gender TEXT NOT NULL ); -- insert some values INSERT INTO students VALUES (1, 'Ryan', 'M'); INSERT INTO students VALUES (2, 'Joanna', 'F'); -- fetch some values -- SELECT * FROM students WHERE gender = 'F';

create view games as --SELECT * FROM students;

SELECT * FROM students order by name;

select * from games;

SQL VIEW 檢視表 / 視圖 - SQL 語法教學 Tutorial

What language is the view? DDL, DCL or DML?

SQL CREATE VIEW, REPLACE VIEW, DROP VIEW Statements

SQL CREATE VIEW Statement

In SQL, a view is a virtual table based on the result-set of an SQL statement.