QUERY 関数 Google ドキュメント エディタ ヘルプ

Aggregates Dept values across 1win peru rows and sorts by the maximum value of Salary. Aggregates Salary values across rows using Select and Group by clauses. Returns rows that match the specified condition using Select and Where clauses.

  • Returns rows that match the specified condition using Select and Where clauses.
  • Aggregates Dept values across rows and sorts by the maximum value of Salary.
  • Aggregates Salary values across rows using Select and Group by clauses.
  • Aggregates Dept values across rows and sorts by the maximum value of Salary.
  • Returns rows that match the specified condition using Select and Where clauses.
  • Aggregates Salary values across rows using Select and Group by clauses.