+ Start a Discussion
PavanReddyPavanReddy 

how to display records ?

Hi All

 

I have 2 lakhs records, out of 2 lakhs i want to display 1 lakh records only? what is the query ?

 

thanksin adavance

 

pavan

souvik9086souvik9086

Give limit.

 

If this post is helpful please throw Kudos.If this post solves your problem kindly mark it as solution.

Thanks

Devendra@SFDCDevendra@SFDC
Hi,

You can go through the following link which gives information on governor limit for salesforce apex.

http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_gov_limits.htm

Total number of records retrieved by SOQL queries = 50,000.

So If you are writing a query then you can specify limit as 50000.
praveen murugesanpraveen murugesan
Hi Pavan,

You need to use LIMIT in query.

At the moment - max limit is 50K in total. This might be limited further for example if you'll query large textarea fields and run out of heap size before running out of query rows.

list<account> acc = [select id from account limit 50000];

Mark this as best answer if its helps.

Thanks.

Praveen Murugesan.