Skip to main content

Query

SELECT語法​

  • 可查詢所有或部分欄位
SELECT columnname FROM tablename;                   查詢指定欄位的值
SELECT columnname AS aliasname FROM tablename;      可以給予別名
SELECT DISTINCT columnname FROM tablename;          查詢結果不會有重複的值

ORDER語法​

  • 將查詢結果排序
  • ORDER BY可以兩個以上的欄位,也可分別指定昇冪或降冪
SELECT columnname 
FROM tablename 
ORDER BY columnname ASC|DESC;

WHERE語法​

  • 依據指定條件查詢
  • 可搭配運算符號 (= <> > < LIKE IN)
SELECT columnname 
FROM tablename 
WHERE condition;