請用　MSFlexGrid元件設計一資料庫, 列出Ford, Toyota, Honda, Bens, BMW, 裕隆 等六家汽車公司的製造國家, 價位, 銷售量, ..

訪客只能看到部份內容，免費 加入會員 或由臉書 Google 可以看到全部內容

利用 SQL 指令來作
Select 廠牌,製造國家, 價位, 銷售量, 服務口碑 From dbName Oder by 銷售量

再把資料顯示出來就可以
================================================
SQL 語法
Select
SELECT "欄位" FROM "表格名"

Distinct
SELECT DISTINCT "欄位" FROM "表格名"

Where
SELECT "欄位" FROM "表格名" WHERE "condition"

And/Or
SELECT "欄位" FROM "表格名" WHERE "簡單條件" {[AND|OR] "簡單條件"}+

In
SELECT "欄位" FROM "表格名" WHERE "欄位" IN ('值1', '值2', ...)

Between
SELECT "欄位" FROM "表格名" WHERE "欄位" BETWEEN '值1' AND '值2'

Like
SELECT "欄位" FROM "表格名" WHERE "欄位" LIKE {模式}

Order By
SELECT "欄位" FROM "表格名" [WHERE "條件"]ORDER BY "欄位" [ASC, DESC]

Count
SELECT COUNT("欄位") FROM "表格名"

Group By
SELECT "欄位1", SUM("欄位2") FROM "表格名" GROUP BY "欄位1"

Having
SELECT "欄位1", SUM("欄位2") FROM "表格名" GROUP BY "欄位1" HAVING (函數條件)

Create Table
CREATE TABLE "表格名"("欄位 1" "欄位 1 資料種類","欄位 2" "欄位 2 資料種類"",... )

Drop Table
DROP TABLE "表格名"

Truncate Table
TRUNCATE TABLE "表格名"

Insert Into
INSERT INTO "表格名" ("欄位1", "欄位2", ...)VALUES ("值1", "值2", ...)

Update
UPDATE "表格名"SET "欄位1" = [新值]WHERE {條件}

Delete From
DELETE FROM "表格名"WHERE {條件}