Top "Google-query-language" questions

Google Query Language is the part of the Google Visualization API that lets the developer perform various data manipulations with the query to the data source.

Google SpreadSheet Query: Can I remove column header?

I'm doing this query at my google spreadsheet: =QUERY(H4:L35;"select sum(L) where H='First Week'"; -1) But …

google-sheets formulas google-sheets-query google-query-language
Google spreadsheet "=QUERY" join() equivalent function?

This question is concerning joining two databases in Google spreadsheet using =QUERY function I have a table like so in …

sql google-sheets google-query-language
Google Spreadsheets QUERY() to combine multiple sheets, same workbook

Goal: I'm using QUERY() in gSheets to combine data from multiple sheets in the same workbook. The data is an …

google-analytics google-sheets google-query-language
SUMIFS function in Google Spreadsheet

I'm trying to have a similar function to SUMIFS (like SUMIF but with more than a single criterion) in a …

performance google-sheets google-query-language
Can the google spreadsheet 'query' function be used in google apps script?

I'm looking for a way to programmatically populate a spreadsheet that filters data from another spreadsheet based on the logged …

google-apps-script google-sheets google-query-language
Is there a way to insert blank columns in output with google sheets query?

Consider the query run from sheet2 =query(Sheet!A7:A, "Select A,B,C where A='Order'") but I want …

google-sheets google-query-language
I got this message (CANNOT_GROUP_WITHOUT_AGG) from a simple query

I how to fix this error message? Unable to parse query string for Function QUERY parameter 2: CANNOT_GROUP_WITHOUT_AGG …

google-sheets spreadsheet google-query-language
Google Sheets Query Language: escape apostrophe

How can I escape an apostrophe inside a SQL query in Google Sheets? Here's my function: =QUERY(QUERY(IMPORTRANGE("XXXXXXX", "…

google-sheets google-sheets-formula google-query-language
Google Sheets - Query Multiple Columns With Custom Labels

I am trying to create a simple query in my Google Sheet that will allow me to label the two …

google-sheets google-query-language