I have a sql query which produces very large data from a remote server but the data is too large to fit into memory all at once. So i want to read and export it sequentially into a csv. I am using the following commands:



but i only get one line. But i want to get 10000 lines each time and export and then move to the next 10000 until all data is moved to the csv. Somebody help!!!


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.