Hi Bob, yea that works and that's something I could run...but I wish that our SQL would report on all fields but total/count odobnm. Also, thanks Rob for this;
SELECT odldat, count(odobnm) as NbrObjects
FROM myfile
where odldat = 090713 or odldat = 090813
group by odldat
order by odldat
-----Original Message-----
From: Bob Levad <blevad@xxxxxxxxxxxxxxxx>
To: 'midrange-l@xxxxxxxxxxxx' <midrange-l@xxxxxxxxxxxx>
Sent: Mon, Sep 9, 2013 10:17 am
Subject: RE: SQL question
Try this:
SELECT COUNT(odobnm)
FROM myfile
WHERE odldat = 090713 OR odldat = 090813
----Original Message-----
rom: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx]
n Behalf Of fbocch2595@xxxxxxx
ent: Monday, September 09, 2013 9:01 AM
o: midrange-l@xxxxxxxxxxxx
ubject: Re: SQL question
i Mark, that doesn't work, says not valid;
Column ODOBNM or expression in SELECT list not valid.
ELECT COUNT(odobnm), odobnm, odldat, odltim
FROM myfile
WHERE odldat = 090713 OR odldat = 090813
ORDER BY odldat
ELECT COUNTodobnm), odobnm, odldat, odltim
FROM myfile
WHERE odldat = 090713 OR odldat = 090813
ORDER BY odldat
-----Original Message-----
rom: Mark S Waterbury <mark.s.waterbury@xxxxxxxxxxxxx>
o: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
ent: Mon, Sep 9, 2013 9:44 am
ubject: Re: SQL question
ELECT 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
nt to know the count or total of the odobnm's in the query...what's the syntax
r 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
-
is is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
post a message email: MIDRANGE-L@xxxxxxxxxxxx
subscribe, unsubscribe, or change list options,
sit:
http://lists.midrange.com/mailman/listinfo/midrange-l
email: MIDRANGE-L-request@xxxxxxxxxxxx
fore posting, please take a moment to review the archives
http://archive.midrange.com/midrange-l.
--
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 electronic transmission and any documents accompanying this electronic
ransmission contain confidential information belonging to the sender. This
nformation may be legally privileged. The information is intended only for the
se of the individual or entity named above. If you are not the intended
ecipient, you are hereby notified that any disclosure, copying, distribution,
r the taking of any action in reliance on or regarding the contents of this
lectronically transmitted information is strictly prohibited.
-
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.
As an Amazon Associate we earn from qualifying purchases.