Google query result without header

Question

The following formula produces a 2-row result for me: a header row and a data row

=QUERY(A1:I7,"select B,C where A=1",-1)

I would like to have a single-row result: just data, without header.

I found similar questions, but none of the answers are applicable to my question, because I do not use SUM() or other aggregate functions.

Google SpreadSheet Query: Can I remove column header? https://productforums.google.com/forum/#!topic/docs/0CPyUKPSl5E https://productforums.google.com/forum/#!topic/docs/UEYtMBH_Wnk

Answer 1

Instead of labeling column names as blanks using '', you can omit all headers like this:

=QUERY('Все'!A1:I7,"select B,C where A=1", 0)

By removing headers from the input, you drop the headers from the output.

Answer 2

I found an answer here:

=QUERY(A1:I7,"select B,C where A=1 label B '',C ''",-1)