After SELECT, only the field name of the table can appear, not an
expression.( )
expression.( )
举一反三
- Assume that the table "employee" has fields such as number, name, age, title, and nationality. The field that can be used as key is(). A: number B: name C: age D: title
- Can you name other diseases? Please write down the complete expression.
- A topic sentence can only appear at the beginning of a paragraph.
- 关于查询中列的别名, 以下()语句是不正确的(选一项) A: Select name as '姓名' from table B: Select name as姓名 from table where id =1 C: Sleect name = 姓名 from table D: Select names姓名 from table
- 下面哪条语句可以查询姓“张”并且年龄等于20岁的用户,请问用哪条语句? A: Select * From table Where name like "%张%" And intAge=20 B: Select * From table Where name like "张%" And intAge=20 C: Select * From table Where name like "张%" And intAge="20" D: Select * From table Where name="张" And intAge=20