grouping when attribute have some null entry..

Question

select state, companyname, count(*) from abovetable group by state, companyname../

Answer 1

Null will cause one group reords 1 10 11 12 will form one group

Comments

i think all should  be there in ans as null treated as different for each entry

---

@ pooja palod here count(*) will be 12 Or 4 ?according to me it is 12