I have below Query

```
select rowid,ConnectionStatus,count(*) Count
from NAIL_CONN
where name like "WorkflowStatusHandlingMDBBeanEJB%"
group by ConnectionStatus

```

which returns me value like

```
rowed  ConnectionStatus Count

8      Connected    1
14      re-connecting   3

```

From this Query the possibility of ConnectionStatus returning are "re-connecting,disconnected and Connected"

I want it to return 0 when no row matches above criteria

example:

```
rowed  ConnectionStatus Count

8      Connected    1
14      re-connecting   3
10     disconnected     0

```

Pls ignore the rowed as it doesn't matter much.