Not true, you can have a group by and not have as part of your select.
Give it a shot! This particular statement will give the max BbCCtT for
every BbAssign where the count of records is greater than 1 for each
BbAssign
--
Michael Schutte
Admin Professional
Announcing Bob Evans Bob-B-Q® Road Trip! For a limited time, America's best
Bob-B-Q® tastes are all at Bob Evans! For more information, visit
www.bobevans.com/menu/seasonal.aspx
MWHopkins@pdpgrou
pinc.com
Sent by: To
rpg400-l-bounces@ RPG programming on the IBM i /
midrange.com System i <rpg400-l@xxxxxxxxxxxx>
cc
05/24/2010 03:16 Subject
PM Re: Embeded SQL Question
Please respond to
RPG programming
on the IBM i /
System i
<rpg400-l@midrang
e.com>
Because BbAssign is not in your select list. If you are grouping by that
field, it has to be in the select.
Matt Hopkins
Sr. Programmer/Analyst
Web: www.pdpgroupinc.com
Email: MWHopkins@xxxxxxxxxxxxxxx
Office: 410-584-0330
Fax: 410-584-0336
Cell: 410-258-8845
From: Jeff Young <cooljeff913@xxxxxxxxx>
To: rpg400-l@xxxxxxxxxxxx
Date: 05/24/2010 03:13 PM
Subject: Embeded SQL Question
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
Given the following SQL Statement, why is the precompiler complaining
about the MAX keyword?
Exec SQL
Set :Last_Start =
Select Max(BbCCtT) From VoCTrack
Where BBAssign = :Assignment and
BBCode = 'STR'
Group by BbAssign
Having Count(*) > 1;
Thanks,
Jeff Young
Sr. Programmer Analyst
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
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
The information contained in this communication may be confidential, is
intended only for the use of the recipient named above, and may be legally
privileged. If the reader of this message is not the intended recipient,
you are hereby notified that any dissemination, distribution, or copying of
this communication, or any of its contents, is strictly prohibited. If you
have received this communication in error, please re-send this
communication to the sender and delete the original message and any copy of
it from your computer system. Thank you.
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
midrange.com
