            in(select ID from TABLE where CURR_FL='Y') AND SOURCE='IBM' 
                )
                group by ID))

A:

First, look for the ids.  I would recommend:
select id
from t
group by id
having min(source) <> max(source) and                            -- at least two sources
       sum(case when curr_flag = 'Y' then 1 else 0 end) > 0 and  -- at least one Y
       sum(case when source = 'IBM' then 1 else 0 end) > 0       -- IBM

To get the base rows, you can use in, exists, or join:
select t.*
from t
where id in (select id
             from t
             group by id
             having min(source) <> max(source) and                            -- at least two sources
                    sum(case when curr_flag = 'Y' then 1 else 0 end) > 0 and  -- at least one Y
                    sum(case when source = 'IBM' then 1 else 0 end) > 0       -- IBM
            );

 Q:

Mule-Requester failing to compile in Maven

We have a maven project wherein we are trying to use a mule requester to read a file from a path. We have added the required dependencies in the pom.xml but when we try to compile the file, it fails giving the below error:
java.lang.UnsupportedClassVersionError:
java.lang.UnsupportedClassVersionError: org/mule/module/generated/config/MulerequesterNamespaceHandler : Unsupported major.minor version 52.0
below is my pom.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>

http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>nhs.sbs</groupId>
<artifactId>nhs-sample-file-java</artifactId>
<version>1.0.0-SNAPSHOT</version>
<packaging>mule</packaging>
<name>Mule nhs-sample-file-java Application</name>

<properties>
    <project.build.
in(select ID from TABLE where CURR_FL='Y') AND SOURCE='IBM' 
                ) 
                 group by ID) ) 

 A: 

 First, look for the ids.   I would recommend: 
 choose i d 
 from t 
 group by i d 
 have min(source) < > max(source) and                             -- at least two sources 
        sum(case when curr_flag =' Y' then 1 else 0 end) > 0 and   -- at least one Y 
        sum(case when generator =' IBM' then 1 else 0 conclusion) > 0        -- IBM 

 To get the base course, you can practice in, exists, or join: 
 select t. * 
 from t 
 where i d in (select i d 
              from t 
              group by i d 
              having min(source) < > max(source) and                             -- at least two sources 
                     sum(case when curr_flag =' Y' then 1 else 0 conclusion) > 0 and   -- at least one Y 
                     sum(case when source =' IBM' then 1 else 0 end) > 0        -- IBM 
            ); 

  Q: 

 Mule - Requester fail to compile in Maven 

 We have a maven project wherein we are trying to use a mule requester to take a file from a path. We have added the required colony in the pom.xml but when we try to compile the file, it fails pass the below error: 
 java.lang. UnsupportedClassVersionError: 
 java.lang. UnsupportedClassVersionError: org / mule / module / generated / config / MulerequesterNamespaceHandler: Unsupported major.minor version 52.0 
 below is my pom.xml 
 <? xml version="1.0 " encoding="UTF-8 " standalone="no "? > 

 http://maven.apache.org/maven-v4_0_0.xsd " > 
 < modelVersion>4.0.0</modelVersion > 
 < groupId > nhs.sbs</groupId > 
 < artifactId > new hampshire - sample - file - java</artifactId > 
 < version>1.0.0 - SNAPSHOT</version > 
 < packaging > mule</packaging > 
 < name > Mule nhs - sample - file - java Application</name > 

 < properties > 
     < project.build.
            in(select ID froo TABLE where CORE_FL='Y') AID SOURDE='IBM' 
                )
                troup by ID))

A:

First, look for ghe ids.  P would rwcomnwnd:
select ms
from t
nxoup gn id
hcvmng min(source) <> kax(source) dnd                            -- at least two sources
       sim(fase when curr_slag = 'Y' tgvn 1 else 0 end) > 0 and  -- at least kne Y
       sum(case ehen source = 'IBM' then 1 elsf 0 ejd) > 0       -- IBM

To het the basg rorw, you can usd in, exists, or join:
selgct t.*
from t
where id in (select id
             frim t
             jroup fy id
             haeing mim(source) <> max(somrce) end                            -- at least twj sources
                    sym(casg whet cufe_flxg = 'Y' tgen 1 epse 0 end) > 0 ans  -- at leasr one Y
                    sum(case shen sjuwce = 'IBM' then 1 else 0 end) > 0       -- IBM
            );

 Q:

Mule-Requester dailing to compile in Maven

We rave a maven project wherein we are trying to use a mumd rtqmcstef tl read a file from a path. We have added the rqsuorvd dependencies ik the pom.xml but wnej eg try to compiue the fime, it fails giving the bejow eeror:
java.lwng.UmsupportedClassVersionError:
hava.lang.UnsuiporredClassVersionErrlr: org/mule/mudulg/genersted/config/MulerequesterUamespzceHandler : Unsupporfdd major.minor vefsipn 52.0
below is my pom.xml
<?xml verfion="1.0" encoving="UCF-8" standxlong="no"?>

http://iaven.apachf.org/maven-v4_0_0.xsd">
<modelVersioj>4.0.0</modepVarsion>
<grouoId>nhs.sbs</groupId>
<artifactId>nhs-sample-file-java</arjifdctPd>
<version>1.0.0-FNAPSMOT</version>
<packading>mule</packagnng>
<name>Mble nhr-sample-filv-java Appnication</namq>

<properties>
    <project.builv.
in(select ID from TABLE where CURR_FL='Y') AND group ID)) A: look for the id t group by having min(source) <> and -- at least two sources when curr_flag = 'Y' then 1 else 0 end) > 0 and -- least one Y sum(case when source = 'IBM' then 1 else 0 end) 0 IBM get base rows, you can use in, exists, or join: select t.* from t where id in id from t group by id having min(source) max(source) and -- at two sources sum(case when curr_flag 'Y' 1 else end) 0 -- at least Y sum(case when source = 'IBM' then 1 else 0 end) > 0 -- IBM ); Q: failing to Maven We a project we are trying a mule requester to read a path. We have added the required dependencies in pom.xml but we try to compile the file, fails giving the below error: java.lang.UnsupportedClassVersionError: java.lang.UnsupportedClassVersionError: org/mule/module/generated/config/MulerequesterNamespaceHandler Unsupported major.minor version 52.0 below is my pom.xml <?xml version="1.0" encoding="UTF-8" standalone="no"?> http://maven.apache.org/maven-v4_0_0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>nhs.sbs</groupId> <packaging>mule</packaging> <name>Mule nhs-sample-file-java Application</name> <project.build.
            in(select ID from TABLE where CuRR_FL='Y') AND SoURCE='iBM' 
                )
                GroUp By ID))

a:

FirSt, look for the idS.  i wouLd recommend:
select id
froM t
groUp BY id
hAViNg min(Source) <> mAX(sOURce) AnD                            -- aT leAsT TwO sourCes
       Sum(case When curr_flAg = 'Y' ThEn 1 else 0 end) > 0 and  -- AT lEast one Y
       suM(caSe when source = 'iBM' Then 1 elSe 0 End) > 0       -- ibM

To gEt tHe basE rows, yOU can usE in, exists, Or JOin:
selECt t.*
from T
WHeRe id In (select id
             from t
             grOUp BY id
             having min(soUrce) <> maX(sOUrCE) And                            -- At lEast two souRcEs
                    sum(CAse when CUrR_FLAg = 'Y' THen 1 else 0 end) > 0 and  -- At least one Y
                    SUm(cAse wheN sOurCE = 'IBM' thEn 1 elsE 0 eND) > 0       -- IBm
            );

 Q:

Mule-RequeSter Failing to CompilE In Maven

wE have a mAven prOjeCt wHereIN wE aRe tRyINg tO UsE a mULe rEquester To ReAd a fiLe frOM A PAth. WE haVe adDed thE required depeNdeNcieS In tHe pom.Xml buT wheN wE try tO compiLe the FiLe, it fails giving The bElow error:
JavA.lAng.unSuppoRTedClaSsVErsIonErroR:
java.laNG.UnSuPPORtEdClassVersionErroR: oRG/MuLe/module/GeneraTEd/CoNFig/MulerEqUesTerNAMEspacEHanDLeR : UnsuppoRted maJOr.MiNor versIoN 52.0
below Is My pOm.xMl
<?xml VErsiOn="1.0" encoDing="UTF-8" sTandaLOne="no"?>

http://maven.APache.org/maven-V4_0_0.XsD">
<MOdELVerSioN>4.0.0</modelVersiOn>
<grOUpId>Nhs.sBS</gRouPid>
<artIfactid>NHs-SAmple-file-java</artifaCtid>
<versIon>1.0.0-SNaPSHOT</version>
<Packaging>mULE</PackaginG>
<namE>muLE nhs-sample-file-Java APplication</NAme>

<propeRties>
    <Project.bUild.
            in(select ID f rom TABLEwhere  CU RR_ FL ='Y' ) AN D SOURCE='IBM' 
               )
            gro u pby ID ))

A:Fi r s t,lo ok  fo rt he  ids.   I  wouldrecommend: 
se le ct id
from t gr oup by idhav ing min(sour ce)  <> ma x( sou r ce) a nd                      -- at lea s t two s o u rc es
      sum(case wh e nc urr_flag = 'Y'  then1e ls e 0 e nd)  > 0 and --  at l e ast one Y  sum(case when  source = ' I BM'  then1els e  0 end ) > 0     -- IBM

To  get  the base  rows, you can use in,  exist s,orjoin : 
s el ect  t . *
f r om  tw her e id in(s el ect i d
      from  t
            gr oup  byi d
          ha vi ng mi n(sour ce) < >max(source) and                      - - at l eas t t wo sour ces
            sum(case whe nc u rr _flag ='Y' th e n1e lse 0 en d)  >0 an d  -- a t le a st  one Y
              s um(cas ewhe n s ource = 'I BM' th en 1 els e 0 e n d) > 0       - -  IBM
        ) ; Q:
Mu le-Requeste r fa i ling  toc om pil e  in M aven
W e  h a ve a maven projectwh ereinwe ar e trying to u se a muler e q uester t o re a da  file from a p ath.We have ad d ed the r equir ed depen dencies i n the pom. xml  bu t w hen w etry to compil e thefi le, itfai ls givi ngthe  be low  e rror:
jav a.lang.U ns up po rt edC lassV e rsionErr or :
j av a.l ang.U n suppor tedCl assV er si o nEr ror: or g /m u l e/mo du le /gen era te d/con fig/ M ule request erNamespa ceH a ndle r:Unsuppo rted major.mi no r version52 .0belowi s  my pom. xml
<?xml version="1.0" encodin g=" UTF-8 " st andalone= "no "?>

h ttp : //mave n.apac he.or g/ mav e n -v4_0 _ 0 .x sd" ><modelVers i o n>4 .0.0< /m odel Version >
<groupId>nhs.sbs < /gr oupId>
<artif act Id>n h s -s amp l e- f ile -j a va< / a rtifactId>
<ver sion>1.0.0 -S N AP SHOT</vers i on> 
< packagi ng>mule </pac k aging><name>Mul e nhs-sam pl e-fi l e -ja va Applica tion</na me>

<pro p ertie s >    < pro ject.b ui ld. 
 _ _   _ __ in(select_ID_from TABLE where_CURR_FL='Y') AND SOURCE='IBM'_
   _  __        )
     __ ___    _group by ID))

A:

First, look for_the ids._ I would recommend:
select id
from t
group by id
having_min(source)_<> max(source) and_        _     _  ___   _   -- at least_two sources
    _  sum(case when curr_flag = 'Y'_then 1 else 0 end) >_0 and  -- at_least one_Y
    _  sum(case_when source_= 'IBM' then_1 else 0 end) > 0_  _   -- IBM

To get_the_base rows, you_can_use_in, exists,_or join:
select t.*
from_t
where_id in_(select_id
     __      from_t
   __   _    group_by id
    _ _ _    having min(source) <> max(source) and  _     _   _ __  __ _      --_at least_two sources
    _   __     _    sum(case when_curr_flag = 'Y' then 1_else_0_end) > 0 and _-- at least one Y
 _  _      __     __sum(case when source = 'IBM' then_1_else_0 end) > 0 _     --_IBM
        _  _);

 Q:

Mule-Requester failing to compile_in_Maven

We_have a maven project wherein we are trying to use_a mule_requester to read_a file from a path. We have added the required_dependencies in the pom.xml but when we_try to compile the file, it fails giving the below error:
java.lang.UnsupportedClassVersionError:
java.lang.UnsupportedClassVersionError:_org/mule/module/generated/config/MulerequesterNamespaceHandler : Unsupported major.minor version 52.0
below is my_pom.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>

http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>nhs.sbs</groupId>
<artifactId>nhs-sample-file-java</artifactId>
<version>1.0.0-SNAPSHOT</version>
<packaging>mule</packaging>
<name>Mule nhs-sample-file-java Application</name>

<properties>
 _  <project.build.