Re: SQL question

[John McKee <jmmckee@xxxxxxxxxxxxxx>]

How about this:

SELECT COUNT(odobnm), odobnm, odldat, odltim
     FROM myfile
     WHERE odldat = 090713 OR odldat = 090813
    Group by odldat
     ORDER BY odldat

Not ideal, as you get two numbers.  Or maybe group on some field that has
same value for every row.

Works in MS-SQL anyway.

John McKee


On Mon, Sep 9, 2013 at 9:01 AM, <fbocch2595@xxxxxxx> wrote:

> Hi Mark, that doesn't work, says not valid;
>
> Column ODOBNM or expression in SELECT list not valid.
>
>
> SELECT COUNT(odobnm), odobnm, odldat, odltim
>      FROM myfile
>      WHERE odldat = 090713 OR odldat = 090813
>      ORDER BY odldat
>
>
>
>
>
>
> SELECT COUNTodobnm), odobnm, odldat, odltim
>     FROM myfile
>     WHERE odldat = 090713 OR odldat = 090813
>     ORDER BY odldat
>
>
>
>
>
> -----Original Message-----
> From: Mark S Waterbury <mark.s.waterbury@xxxxxxxxxxxxx>
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Sent: Mon, Sep 9, 2013 9:44 am
> Subject: Re: SQL question
>
>
> SELECT COUNTodobnm), odobnm, odldat, odltim
>     FROM myfile
>     WHERE odldat = 090713 OR odldat = 090813
>     ORDER BY odldat
>  > On 9/9/2013 9:23 AM, fbocch2595@xxxxxxx wrote:
>  Hi Folks, when I use the following statement I get a list of files but
> now I
> ant to know the count or total of the odobnm's in the query...what's the
> syntax
> or that or how can I get that number within by adding to the select
> statement?
>  Thanks, Frank
>
>  SELECT odobnm, odldat, odltim FROM myfile
>  where odldat = 090713 or odldat = 090813
>  order by odldat
>
>
> --
> his is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> o post a message email: MIDRANGE-L@xxxxxxxxxxxx
> o subscribe, unsubscribe, or change list options,
> isit: http://lists.midrange.com/mailman/listinfo/midrange-l
> r email: MIDRANGE-L-request@xxxxxxxxxxxx
> efore posting, please take a moment to review the archives
> t http://archive.midrange.com/midrange-l.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.