MCQs>IT & Programming>Google Sheets>Consider the four columns in a Google Sheets spreadsheet having titles colA, coIB, coIC and coID respectively. If you want to execute a query on these columns having a group by clause, then what will be the correct syntax for the query?
Google Sheets MCQs
Consider the four columns in a Google Sheets spreadsheet having titles colA, coIB, coIC and coID respectively. If you want to execute a query on these columns having a group by clause, then what will be the correct syntax for the query?
Answer
Correct Answer:
=QUERY(Sheet1!1:1000,"select colD,max(colC) group by colD")
Explanation:
Note: This Question is unanswered, help us to find answer for this one