Re: Sub Count

Hi. On Mon, Nov 12, 2001 at 01:26:01PM -0800, [EMAIL PROTECTED] wrote: > Howdy, > > I'm trying to write a select statement that produces a SUB COUNT of column > PORT_STATUS where (A) PORT_STATUS = 'up' and (B) PORT_STATUS = 'down'. I'd >

Re: Sub Count -- Correction

> Brad > > I'm trying to write a select statement that produces a SUB COUNT of column > PORT_STATUS where (A) PORT_STATUS = 'up' and (B) PORT_STATUS = 'down'. I'd > like to do this in one statment with GROUP by LOCATION_T.ADDRESS, > LOCATION_T.CITY wit

Sub Count -- Correction

Sorry, for some reason, the select statement was cut off. Here is the complete statement (below): Thanks, Brad I'm trying to write a select statement that produces a SUB COUNT of column PORT_STATUS where (A) PORT_STATUS = 'up' and (B) PORT_STATUS = 'down'. I'd l

Sub Count

Howdy, I'm trying to write a select statement that produces a SUB COUNT of column PORT_STATUS where (A) PORT_STATUS = 'up' and (B) PORT_STATUS = 'down'. I'd like to do this in one statment with GROUP by LOCATION_T.ADDRESS, LOCATION_T.CITY without altering the outer