topic Re: how to write a select query to get 200000 rows from database in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-write-a-select-query-to-get-200000-rows-from-database/m-p/4030514#M963267 <HTML><HEAD></HEAD><BODY><P>select * from &lt;table &gt; into table &lt;internal table &gt;</P><P> up to 200000 rows.</P></BODY></HTML> Fri, 20 Jun 2008 10:38:23 GMT Former Member 2008-06-20T10:38:23Z how to write a select query to get 200000 rows from database https://community.sap.com/t5/application-development-and-automation-discussions/how-to-write-a-select-query-to-get-200000-rows-from-database/m-p/4030513#M963266 <HTML><HEAD></HEAD><BODY><P>how to write a select query to get 200000 rows from database</P></BODY></HTML> Fri, 20 Jun 2008 10:37:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-write-a-select-query-to-get-200000-rows-from-database/m-p/4030513#M963266 Former Member 2008-06-20T10:37:11Z Re: how to write a select query to get 200000 rows from database https://community.sap.com/t5/application-development-and-automation-discussions/how-to-write-a-select-query-to-get-200000-rows-from-database/m-p/4030514#M963267 <HTML><HEAD></HEAD><BODY><P>select * from &lt;table &gt; into table &lt;internal table &gt;</P><P> up to 200000 rows.</P></BODY></HTML> Fri, 20 Jun 2008 10:38:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-write-a-select-query-to-get-200000-rows-from-database/m-p/4030514#M963267 Former Member 2008-06-20T10:38:23Z Re: how to write a select query to get 200000 rows from database https://community.sap.com/t5/application-development-and-automation-discussions/how-to-write-a-select-query-to-get-200000-rows-from-database/m-p/4030515#M963268 <HTML><HEAD></HEAD><BODY><P><STRONG>HI,</STRONG></P><P></P><P><STRONG>IF u fetch huge amount of data it will reduce ur program performance go for pacakage size format of select query</STRONG></P><P></P><P>syntax</P><P></P><P> *SELECT * FROM spfli INTO TABLE it_spfli PACKAGE SIZE 10000.*</P><P></P><P>go throu this link</P><P></P><P><STRONG>[http://sap-img.com/abap/package-size.htm]</STRONG></P><P></P><P><STRONG>Regards,</STRONG></P><P><STRONG>priya</STRONG></P></BODY></HTML> Fri, 20 Jun 2008 10:43:15 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-write-a-select-query-to-get-200000-rows-from-database/m-p/4030515#M963268 Former Member 2008-06-20T10:43:15Z Re: how to write a select query to get 200000 rows from database https://community.sap.com/t5/application-development-and-automation-discussions/how-to-write-a-select-query-to-get-200000-rows-from-database/m-p/4030516#M963269 <HTML><HEAD></HEAD><BODY><P>thnx srinivas</P></BODY></HTML> Fri, 20 Jun 2008 10:46:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-write-a-select-query-to-get-200000-rows-from-database/m-p/4030516#M963269 Former Member 2008-06-20T10:46:43Z Re: how to write a select query to get 200000 rows from database https://community.sap.com/t5/application-development-and-automation-discussions/how-to-write-a-select-query-to-get-200000-rows-from-database/m-p/4030517#M963270 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>To select 20,000 rows from the table use the following select query</P><P></P><P>SELECT &lt;f1&gt; &lt;f2&gt; from &lt;table name&gt; into table &lt;internal tab&gt; upto 20000 rows.</P><P></P><P></P><P></P><P></P><P></P><P>Regards,</P><P>vineela.</P></BODY></HTML> Fri, 20 Jun 2008 10:48:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-write-a-select-query-to-get-200000-rows-from-database/m-p/4030517#M963270 Former Member 2008-06-20T10:48:19Z Re: how to write a select query to get 200000 rows from database https://community.sap.com/t5/application-development-and-automation-discussions/how-to-write-a-select-query-to-get-200000-rows-from-database/m-p/4030518#M963271 <HTML><HEAD></HEAD><BODY><P>hi priya</P><P></P><P>thnx for ur reply </P><P>u mean to say it may go to dump when we are fetching huge data?</P></BODY></HTML> Fri, 20 Jun 2008 10:50:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-write-a-select-query-to-get-200000-rows-from-database/m-p/4030518#M963271 Former Member 2008-06-20T10:50:53Z