單項選擇題

現(xiàn)有表Employee,字段:id(int)、firstname(varchar)、lastname(varchar);以下sql語句錯誤的是()

A.select firstname+’.’+lastnameas’name’from employee
B.select firstname+’.’+lastname=’name’from employee
C.select’name’=firstname+’.’+lastnamefrom employee
D.select firstname,lastname from employee

微信掃碼免費搜題