RE: SQL question

Try this:

SELECT COUNT(odobnm)
FROM myfile
WHERE odldat = 090713 OR odldat = 090813


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of fbocch2595@xxxxxxx
Sent: Monday, September 09, 2013 9:01 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: SQL question


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.

This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.