AnkitWare SQL

Pages

Home
Quick Guide
SQL LAB @ HOME 2
SQL LAB @HOME 3

Friday 21 March 2014

CREATE VIEW

CREATE VIEW :

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

Posted by Ankit Sharma at 06:23

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

Labels: SQL Statement CREATE VIEW

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Labels

Data Models (1)
Database Management System (1)
Object-Based Logical Model (1)
Query data using SQL Server (1)
SQL Statement ALTER TABLE (1)
SQL Statement And/Or (1)
SQL Statement AS (alias) (1)
SQL Statement BETWEEN (1)
SQL Statement CREATE DATABASE (1)
SQL Statement CREATE INDEX (1)
SQL Statement CREATE TABLE (1)
SQL Statement CREATE VIEW (1)
SQL Statement DELETE (1)
SQL Statement DROP DATABASE (1)
SQL Statement DROP INDEX (1)
SQL Statement DROP TABLE (1)
SQL Statement FULL JOIN (1)
SQL Statement GROUP BY (1)
SQL Statement HAVING (1)
SQL Statement IN (1)
SQL Statement INNER JOIN (1)
SQL Statement INSERT INTO (1)
SQL Statement LEFT JOIN (1)
SQL Statement LIKE (1)
SQL Statement ORDER BY (1)
SQL Statement RIGHT JOIN (1)
SQL Statement SELECT (1)
SQL Statement SELECT * (1)
SQL Statement SELECT DISTINCT (1)
SQL Statement SELECT INTO (1)
SQL Statement SELECT TOP (1)
SQL Statement TRUNCATE TABLE (1)
SQL Statement UNION (1)
SQL Statement UNION ALL (1)
SQL Statement UPDATE (1)
SQL Statement WHERE (1)
Window app lab@home 2 (1)

Blog Archive

▼ 2014 (37)
- ▼ March (32)
  - WHERE
  - UPDATE
  - UNION ALL
  - UNION
  - TRUNCATE TABLE
  - SELECT TOP
  - SELECT INTO
  - SELECT DISTINCT
  - SELECT *
  - SELECT
  - ORDER BY
  - LIKE
  - FULL JOIN
  - RIGHT JOIN
  - LEFT JOIN
  - INNER JOIN
  - INSERT INTO
  - IN
  - HAVING
  - GROUP BY
  - DROP TABLE
  - DROP INDEX
  - DROP DATABASE
  - DELETE
  - CREATE VIEW
  - CREATE INDEX
  - CREATE TABLE
  - CREATE DATABASE
  - BETWEEN
  - AS (alias)
  - ALTER TABLE
  - SQL Statement
- ► February (5)

► 2013 (3)
- ► October (1)
- ► August (1)
- ► July (1)

About Me

Ankit Sharma

View my complete profile

Simple theme. Powered by Blogger.