function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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.