4) 现有表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