SOQL Scenario- 5

-
Aggregate functions

 public class SoqlQuery5 {
    public list<Account> acc{set;get;}
    public Integer count{set;get;}
    public Decimal summ{set;get;}
    Public decimal ttal{set;get;}
    public Decimal mm{set;get;}
    public Decimal mn{set;get;}
    public SoqlQuery5(){
        acc=[select Id, name, phone from account where name='s' limit 5];
        count=[select count() from Account where name='s' ];
        Aggregateresult result=[select sum(AnnualRevenue) amt, Avg(AnnualRevenue) total, Min(AnnualRevenue) minm, Max(AnnualRevenue) maxm from Account];
        summ=(Decimal)result.get('amt');
        ttal=(decimal)result.get('total');
        mm=(Decimal)result.get('minm');
        mn=(Decimal)result.get('maxm');
    }  
}

 <apex:page controller="SoqlQuery5">
    <apex:form >
    <apex:pageBlock >
        <apex:pageBlockTable value="{!acc}" var="a">
            <apex:column headerValue="Name" value="{!a.name}" />
                <apex:column headerValue="phone" value="{!a.phone}" />
            </apex:pageBlockTable>
            <apex:pageBlocksection>
            Total No of Accounts<apex:outputText>{!count}</apex:outputText>
            Sum Of the Amount   <apex:outputText>{!summ}</apex:outputText>
            Average of Amount <apex:outputText>{!ttal}</apex:outputText>
            Minimum <apex:outputText>{!mm}</apex:outputText>
            Max <apex:outputText>{!mn}</apex:outputText>
            </apex:pageBlocksection>
        </apex:pageBlock>
    </apex:form>
</apex:page>

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                No       No        No 2.     Ok         No            No                 Ok       No      No 3.     Ok         No            NO                Ok       OK     No 4.     Ok          No           NO                OK      No       OK
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