SELECT [栏位1,栏位2…] FROM [资料表名称] WHERE [条件]

ORDER BY [排序栏位1,排序栏位2...] ASC/DESC 

GROUP BY [群组栏位]

LIMIT 开始,笔数

例：查询资料表member的全部资料，显示account跟password栏位

SELECT account,password FROM member

例：查询资料表member的全部资料，显示全部栏位

SELECT * FROM member

例：查询资料表member内account有abc及password是1234的资料，显示全部栏位

 SELECT * FROM member WHERE account='abc' AND password='1234'

例：查询资料表member的全部资料, 依account递增排序，显示全部栏位

SELECT * FROM member ORDER BY account ASC

例：查询资料表member的全部资料, 依account递减排序，显示全部栏位

SELECT * FROM member ORDER BY account DESC

例：查询资料表member的全部资料, 依account为群组，显示全部栏位

SELECT * FROM member GROUP BY account 

例：查询资料表member的0笔开始，显示10笔, 显示全部栏位

SELECT * FROM member LIMIT 0,10