Soql Operations

-

SOQL Comparison Operators

Operator
Common name
=
Equals
!=
Not equals
< 
Less than
<=
Less than or equal
> 
Greater than
>=
Greater than or equal
IN
In
NOT IN
Not in (WHERE clause)
INCLUDES EXCLUDES
Applies to multi-select picklists




















Comments

Post a Comment

Popular posts from this blog

Page Layouts

-
1. What is PageLayout? A: Pagelayout controls which fields will be displays in which order they will displayed ,which formate that field should be displayed. 2.How many pageLayouts can be assigned to a profile on a object? A: For every profile only one pagelayout is define. 3. What we can controll using pageLayout? A:Fields. 4. How to add Custom button on the PageLayout? A: Drag and drop 5. How to add Custom button relateed list in the pageLayout? A: 6. Find out what type of access is provided on the field when we have following combination             Field Level Security           Page Layout                    output?       Visable   Read     Required     Visable   Read   Required  1.     Ok         No            No         ...
Read more

SOQL Scenario-1

-
Image
Fetch the Name Fields from Account Object public class SoqlQuery1 {     public List<Account> acc{set;get;}     public SoqlQuery1(){         acc=[select id, name from Account];     } } <apex:page controller="SoqlQuery1" >     <apex:form >     <apex:pageBlock >         <apex:pageBlockSection >             <apex:pageBlockTable value="{!acc}" var="a">                     <apex:column headerValue="Name" value="{!a.name}" />                 </apex:pageBlockTable>             </apex:pageBlockSection>         </apex:pageBlock>     </apex:form> </apex:page>
Read more