V S Pavan Gadey: July 2008

SQL > SQL Syntax

In this page, we list the SQL syntax for each of the SQL commands in this tutorial. For detailed explanations of each SQL syntax, please go to the individual section by clicking on the keyword.

The purpose of this page is to have a quick reference page for SQL syntax, so you can learn SQL more quickly. Bookmark this page now by pressing Control-D so you can have this syntax page handy.

Select Statement
SELECT "column_name" FROM "table_name"

Distinct
SELECT DISTINCT "column_name"
FROM "table_name"

Where
SELECT "column_name"
FROM "table_name"
WHERE "condition"

And/Or
SELECT "column_name"
FROM "table_name"
WHERE "simple condition"
{[AND|OR] "simple condition"}+

In
SELECT "column_name"
FROM "table_name"
WHERE "column_name" IN ('value1', 'value2', ...)

Between
SELECT "column_name"
FROM "table_name"
WHERE "column_name" BETWEEN 'value1' AND 'value2'

Like
SELECT "column_name"
FROM "table_name"
WHERE "column_name" LIKE {PATTERN}

Order By
SELECT "column_name"
FROM "table_name"
[WHERE "condition"]
ORDER BY "column_name" [ASC, DESC]

Count
SELECT COUNT("column_name")
FROM "table_name"

Group By
SELECT "column_name1", SUM("column_name2")
FROM "table_name"
GROUP BY "column_name1"

Having
SELECT "column_name1", SUM("column_name2")
FROM "table_name"
GROUP BY "column_name1"
HAVING (arithematic function condition)

Create Table Statement
CREATE TABLE "table_name"
("column 1" "data_type_for_column_1",
"column 2" "data_type_for_column_2",
... )

Drop Table Statement
DROP TABLE "table_name"

Truncate Table Statement
TRUNCATE TABLE "table_name"

Insert Into Statement
INSERT INTO "table_name" ("column1", "column2", ...)
VALUES ("value1", "value2", ...)

Update Statement
UPDATE "table_name"
SET "column_1" = [new value]
WHERE {condition}

Delete From Statement
DELETE FROM "table_name"
WHERE {condition}

V S Pavan Gadey

Wednesday, July 30, 2008

PowerMenu

Tuesday, July 29, 2008

Vista wallpapers collection by gadeypavan

Tuesday, July 22, 2008

cpp project Address_Book by pavangadey

Monday, July 21, 2008

Sql Syntax

Friday, July 4, 2008

C Language interview questions i collected

New York

About Me

Blog Archive