当前学科:结构化查询语言(SQL)
  • 题目: 单选
    有名为 Sales 的表,现需要按客户姓名(CustomerName)和销售日期(SalesDate)排序返回销售数据。为每个客户提供最近期的销售必须首先列出。应使用的查询语句为()

      A . select CustomerName,SalesDate from Sales group by CustomerName,SalesDate
      B . select CustomerName,SalesDate from Sales order by CustomerName,SalesDate
      C . select CustomerName,SalesDate from Sales group by CustomerNameorderbySalesDateDESC
      D . select CustomerName,SalesDate from Sales order by CustomerName,SalesDateDESC

    答案: <查看本题扣1积分>

    查看答案

    答案不对?请尝试站内搜索