• 2022-06-19
    在员工管理系统中,查询表employee表中所有员工的姓名,字段:id(int),firstname(varchar),lastname(varchar),以下sql语句正确的是()。
    A: Select firstname +’.’+ lastname as ‘name’ from employee
    B: Select firstname +’.’+ lastname from employee
    C: Select ‘name’= firstname +’.’+ lastname from employee
    D: Select firstname,lastname from employee
  • 举一反三