现有表 Employee ,字段: id (int) , firstname(varchar), lastname(varchar); 以下 sql 语句错误的是()。
A.
select firstname+'.'+lastname as 'name' from employee )
B.
select firstname+'.'+lastname='name' from employee
C.
select 'name'=firstname+'.'+lastname from employee
D.
select firstname,lastname from employee