Why can't I use alias in a count(*) "column" and reference it in a having clause?

I was wondering why can't I use alias in a count(*) and reference it in the having clause. For instance:

select Store_id as StoreId, count(*) as _count
    from StoreProduct
    group by Store_id
        having _count > 0

Wouldn't work.. But it works if I remove _count and use count(*) instead.

sql sql-server alias

Edit Report

0 Answers