How to compare two rows from the same table without additional join or from?

Question

SQL

Suppose there are a number of conditions that limit the set to 5 - 10 rows
The table has a large data size
Select a row where status is OPEN, but if there is another row with status status - CLOSED
Where statusId is equal for two rows.
Is it possible to work with a selection of 5-10 rows and not join a huge table?

Answer 1

You can fill in the query result, these same 5-10 lines, into a temporary table and continue working with it. Then you don't have to join a large table.

Answer 2

Yes, make a selection and join it to itself.

Answer 3

The question, as always, is stupid.
Sounds like "can you eat soup without a spoon?". And further in justification ridiculous fears.
You should not be afraid to "join a huge table" but learn how to optimize queries.
In this case, there is no problem with the join.
If it slows down, put the desired index, at least by statusId