select表列名1into:变量名1from表名where表列名1=:变量名2;这个语句怎么解释?

假设某表有三个字段：列名1、列名2、列名3，要查询该表的所有记录，写法正确的是： A: SELECT *列名1,列名2,列名3,…… FROM 表名; B: SELECT 列名1,列名2,列名3,…… FROM 表名; C: SELECT 列名1,列名2,列名3FROM 表名; D: SELECT *FROM 表名; E: SELECT 列名3,列名2,列名1FROM 表名; F: SELECT 列名1列名2 列名3FROM 表名; G: SELECT 列名2,列名1,列名3FROM 表名; H: H. SELECT 列名1;列名2;列名3FROM 表名; I: I. SELECT 列名1、列名2、列名3FROM 表名; J: J. SELECT {列名1,列名2,列名3,……}FROM 表名; K: K. SELECT {列名1,列名2,列名3}FROM 表名; L: L. SELECT 列名1,列名3,列名2FROM 表名;

If shipment is to be made during September/October，when should you ship the goods____ A: from September 1 to October 1 B: from September 1 to October 31 C: from September 30 to October 31 D: from September 1 to October 30

写出条件查询“表1 里的字段1的id是多少”（） A: select * from 表1 where字段1=“值” B: select id from 表1 where字段1=“值” C: select id from 字段1 where表1=“值” D: select id from 表1

1 This is a letter from __________ to _____________.

1.toddler age is from what time to what time? A: from delivery to 1 year old B: from 1 to 3 years old C: from fertilized ovum to delivery D: from umbilical ligation to 28thday E: from 6-7 years old to adolescence

查询“学生”表中“学号 char(10)”尾字符是"1"的错误命令是（ ）。 A: SELECT * FROM 学生 WHERE 学号 LIKE '_1' B: SELECT * FROM 学生 WHERE 学号 LIKE '%[1]' C: SELECT * FROM 学生 WHERE 学号 LIKE '%1' D: SELECT * FROM 学生 WHERE RIGHT(学号,1)='1'

下面检索结果一定不是一行的命令： A: select distinct * from orders ; B: select * from orders limit 1，2; C: select top 1 * from orders; D: select * from orders limit 1;

以下可以正确运行的查询语句有( ) A: select * from user ; B: select * from user where username =’李四’; C: select * from user where 1=1; D: select distinct * from user;

查询学生表中学号(字符型,长度为2)末尾字符是"1"的错误命令是( ). A: SELECT * FROM 学生 WHERE SUBSTR(学号,2,1)="1" B: SELECT * FROM 学生 WHERE "1" $ 学号 C: SELECT * FROM 学生 WHERE SUBSTR(学号,2)="1" D: SELECT * FROM 学生 WHERE RIGHT(学号,1)="1"