MVSFORUMS.com

spalanis · Beginner Joined: 19 Jul 2006 Posts: 32 Topics: 15

If my select statement has :
SELECT
B.POL_NO,
B.POL_EFF_DT,
B.POL_EXP_DT,
A.INSD_NM,
B.TTL_NET_PRM,
B.ISSUING_CO_NO,
B.PRODUCER_NO,
B.REGION_CD,
D.COMPOSITE_LOSS_IN,
(SUBSTR(C.EXTRACT_DATA_TX,125,2)) AS GARSTATE,
COUNT(SUBSTR(C.EXTRACT_DATA_TX,31,4)) AS VEHCOUNT

then what should be my Group by fields???????

Please note: My last two fields are extracts from same field.

kolusu · Posted: Tue Nov 18, 2008 12:47 pm Post subject:

spalanis,

Please search before posting . Check this link for an example

http://www.mvsforums.com/helpboards/viewtopic.php?t=5855&highlight=group+substr

Kolusu