What word is missing from the following SQL statement?
__________ count(*) from tablename;
(Please specify the missing word using lower-case letters only.)
Answer: select
题解
SELECT 叙述的基本用法如下:
SELECT * from tablename
如果要指定查找的字段及顺序,可以写成:
SELECT column1, column2, column3, ... from tablename
如果要计算查找的结果列数,可以写成:
SELECT count(*) from tablename
SQL 的关键字没有区分大小写,所以「SELECT」也可以写成「select」。
