How to Split Output file using SQL?

Analytics

How to Split Output file using SQL?

Dear Experts,

Is there any function to split the output file into difference files, irregarless the file format?
i.e: By Row, by file size, by sampling, by attributes

To split every 1000th row of total 10,200 row.
The output:
11 Files (1000 row for each files + 1 file with remaining 200 row)

To split by sampling of 20%,40% and 40%
The output:
File 1 - 20% of total Data
File 2 - 40% of total Data
File 3 - 40% of total Data

Many thanks in advance.
1 REPLY
Enthusiast

Re: How to Split Output file using SQL?

If you can use unix, there's the split command up to the task ...