+ Start a Discussion
yuvraj.chaudhari88@gmail.comyuvraj.chaudhari88@gmail.com 

PLZ REPLY ME FAST--

write an SOQL to fetch all the opportunities where more than one record exist with same mame and name contain "ABC"
Subramani_SFDCSubramani_SFDC
SELECT ID, Name from opportunity WHERE Name = 'ABC'
Subramani_SFDCSubramani_SFDC
select id,name from opportunity where Name like '%ABC%'
Ranu Jain SFDCRanu Jain SFDC
Hii,

You have to use apex logic(for loop) for achieve " where more then one record" exist. So just write a simple query 
select id,name from opportunity where Name like '%ABC%'
and use apex logic to filter out the results.