Query Behavior

Hi,

The output it 100% correct.

You should understand that Partition by will be applied after applying WHERE clause. The execution will be done as follows:

1. Filter out the rows by where clause

2. Apply "Partition by"

In this case, because of where clause, there is only one row, so your count is 1.

Thanks,

---

Tejas Shah

SQL YOGA