Re: SQL Question

[fbocch2595@xxxxxxx]

Thanks Jeff, now I'm trying to use desc to sort the counts.  That doesn't seem 
to be possible.  
 
 
 
-----Original Message-----
From: cooljeff913@xxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Sent: Wed, 7 Feb 2007 12:30 PM
Subject: Re: SQL Question


Try this :
Select Jojob,Count(*)
FROM jrnfile WHERE joentt = 'LD'
Group by Jojob

This gives you a list of the jobs and total number of entries for each job.
 
Jeff Young 
Sr. Programmer Analyst
Dynax Solutions, Inc.
A wholly owned subsidiary of enherent Corp.
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer 
V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions 
Implementer V5R3 


  
 





----- Original Message ----
From: "fbocch2595@xxxxxxx" <fbocch2595@xxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Sent: Wednesday, February 7, 2007 11:47:21 AM
Subject: Re: SQL Question


Hi Dwayne, that only gives me 1 total but I'd like to see all the jobs that 
create these LD entries and count/total on them.  



-----Original Message-----
From: Dwayne.Allison@xxxxxxxxxxxxxxxxxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Sent: Tue, 6 Feb 2007 4:02 PM
Subject: RE: SQL Question


Just enter

SELECT count(*) FROM jrnfile WHERE joentt = 'LD'



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of fbocch2595@xxxxxxx
Sent: Tuesday, February 06, 2007 2:49 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: SQL Question

Yes, I wanted a value of the # of jojob's where joentt is LD.  



-----Original Message-----
From: mrosinger@xxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Sent: Tue, 6 Feb 2007 3:05 PM
Subject: Re: SQL Question


Frank,

Did you mean for each unique value of JOJOB you want a count of that
grouping? If so, Don's response is correct. I understood from your
posting that you wanted a total where joentt is "LD".

--
Regards,

Michael Rosinger
Systems Programmer / DBA
Computer Credit, Inc.
640 West Fourth Street
Winston-Salem, NC  27101
336-761-1524
m rosinger at cciws dot com
"Don Tully Sr" <donald.tully@xxxxxxx> wrote in message
news:mailman.2364.1170791734.2713.midrange-l@xxxxxxxxxxxxxxx
> Select JOjob, count(*) from jrnfile where joentt='LD'
> group by Jojob
>
> Don
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> fbocch2595@xxxxxxx
> Sent: Tuesday, February 06, 2007 1:40 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: SQL Question
>
> Hi folks, here's my statement;
>
> SELECT * FROM jrnfile WHERE joentt = 'LD' ORDER BY JOJOB
>
> I'm looking to get a total of the jojob entries that have joentt of
LD. 
> How
> is that done?
>
> Thanks, Frank
>
>
>
> ______________________________________________________________________
> __ Check out the new AOL.  Most comprehensive set of free safety and 
> security tools, free access to millions of high-quality videos from 
> across the web, free AOL Mail and more.
> --
> 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 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.
________________________________________________________________________
Check out the new AOL.  Most comprehensive set of free safety and
security tools, free access to millions of high-quality videos from
across the web, free AOL Mail and more.
--
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.