Query Formula – 2 in Google Sheet

Query Formula – 2 in Google Sheet

Query formula in Google Sheets is a versatile function that allows you to retrieve and filter data from a specified range or table. The basic syntax of the formula is:

=QUERY(data, query, [header_row])

• data: the range or table of data that you want to query.
• query: the SQL-like query that specifies what data to retrieve and how to filter it.
• [header_row]: an optional parameter that indicates whether the first row of the data contains headers or not.

For example, to retrieve all data from a table named "Sales" and filter it to show only rows where the value in column A is greater than 100, you can use the following formula:

=QUERY(Sales, "SELECT * WHERE A > 100")