现有表Employee,字段:id(int)、firstname(varchar)、lastname(varchar);以下sql语句错误的是()
- Aselect firstname+’.’+lastnameas’name’from employee
- Bselect firstname+’.’+lastname=’name’from employee
- Cselect’name’=firstname+’.’+lastnamefrom employee
- Dselect firstname,lastname from employee