• 2022-06-19
    Employees表中lastname列保存顾客的姓,firstname列保存顾客的名。现在需要查询顾客姓名的组合,例如lastname列中的“张”,同一行firstname列中的“国华”,查询结果应该返回“张国华”,则正确的查询语句应该是()
    A: select lastname,firstname from employees
    B: select * from employees order by lastname,firstname
    C: select lastname+firstname from employees
    D: select lastname and firstname from employees
  • C

    举一反三

    内容

    • 0

      通过 SQL,在表 Actor 中选择 FirstName 等于 Jim 而 LastName 等于 Carter 的所有记录的表述正确的是( )。 A: SELECT * FROM Actor WHERE FirstName LIKE 'Jim' AND LastName LIKE 'Carter' B: SELECT FirstName='Jim', LastName='Carter' FROM Actor C: SELECT * FROM Actor WHERE FirstName='Jim' AND LastName='Carter' D: SELECT * FROM Actor WHERE FirstName='Jim' OR LastName='Carter'

    • 1

      通过 SQL,您如何在表 Persons 中选择 FirstName 等于 Thomas ,并 且LastName 等于 Carter 的所有记录? A: SELECT * FROM Persons WHERE FirstName LIKE 'Thomas' AND LastName LIKE 'Carter' B: SELECT FirstName='Thomas', LastName='Carter' FROM Persons C: SELECT * FROM Persons WHERE FirstName='Thomas' AND LastName='Carter'

    • 2

      下面代码的输出是什么?() functionPerson(firstName,lastName){ this.firstName=firstName; this.lastName=lastName; } constlydia=newPerson("Lydia","Hallie"); constsarah=Person("Sarah","Smith"); console.log(lydia); console.log(sarah); A: Person{firstName:"Lydia",lastName:"Hallie"}andundefined B: Person{firstName:"Lydia",lastName:"Hallie"}andPerson{firstName:"Sarah",lastName:"Smith"} C: Person{firstName:"Lydia",lastName:"Hallie"}and{} D: Person{firstName:"Lydia",lastName:"Hallie"}andReferenceError

    • 3

      从"actor"表中选取"FirstName"列的SQL语句是()。 A: select actor.FirstName B: select FirstName from actor C: extract FirstName from actor D: update FirstName from actor

    • 4

      通过 SQL,根据 "FirstName" 列降序地从 "Actor" 表返回所有记录的正确表述是 A: SELECT * FROM Actor SORT BY 'FirstName' DESC B: SELECT * FROM Actor ORDER FirstName DESC C: SELECT * FROM Actor SORT 'FirstName' DESC D: SELECT * FROM Actor ORDER BY FirstName DESC