Google Sheets | QUERY | Function | Example | Spreadsheet | Tutorial | Select Clause | Extract Data

In the list of Google Sheets most powerful functions, the QUERY function is in the top range of the list. As the name suggests, you can query a data range and extract specific data in a certain way. QUERY uses the Google Visualization API Query Language.
-------------------------------------
How to Use XLOOKUP to Extract Multiple Values in Google Sheets?
XLOOKUP can return a single row or column with the search key:
• Google Sheets | XLOOKU...
-------------------------------------
How to Use VLOOKUP in Google Sheets?
Use VLOOKUP to get a single value:
• VLOOKUP Google Sheets ...
-------------------------------------
How to Use IFS in Google Sheets?
IFS allow multiple logical expressions:
• Google Sheets IFS | Te...
-------------------------------------
How to Use IF in Google Sheets?
Use IF to compare one value with another:
• Google Sheets IF | Tut...
-------------------------------------
How to Use IF with AND in Google Sheets?
Use IF with AND to Use Multiple Logical Expressions in IF:
• Google Sheets | IF | A...
-------------------------------------
How to Create a Pivot Table in Google Sheets?
Create a pivot table for calculation and in-depth data analysis:
• Google Sheets | Pivot ...
-------------------------------------
Which one to Use? A Pivot Table, or COUNTBLANK Function, to Count Blank Cells in Google Sheets:
Gives steps to use a pivot table or COUNTBLANK to count blank cells:
• Google Sheets | Pivot ...
-------------------------------------
How to Use a Pivot Table to Sum by Rows or Columns without using Formula in Google Sheets?
Sum numbers by rows and or columns easily, using a pivot table:
• Google Sheets | Pivot ...
-------------------------------------
How to Create a Pivot Table to Get Maximum Value without Using Formula in Google Sheets?
A pivot table assists to get the maximum value in a data range without using a formula:
• Google Sheets | Pivot ...
-------------------------------------
Let's look at the syntax of the QUERY function formula:
=QUERY(data, query, [headers])
data is the data range you want to query.
query is the command that follows the Google Visualization API Query Language syntax.
headers is optional, and specifies the number of headers.
Here is an example of the Google Sheets QUERY function formula:
=QUERY(sales_data, "select * A, B')
This query returns all the data in the columns A and B.
sales_data is the named data range.
Query part of the formula should be enclosed between double quotes.
select command retrieves specific or all the columns. SELECT * retrieves
all the columns.
NOTE: Column labels, such as A, B, etc., should be in upper case.
Checkout this video tutorial, which gives the step to use the Google Sheets
QUERY function to extract data, with examples.