question

Alain_LePage avatar image
Alain_LePage asked

how to gather the minimum and the maximum value of a specific field in all table found in a folder

Hello,

I would like to know if there is a nice way in SQL to first get the list of file (dataset) in a folder and put it those file name into a file, there after use the latter file produce to get the min and max value of a specific field, like transaction_date and gatther all this information in an output file as below:


file A 01082021 03082021

file B 04082021 04082021

...

file Z 09092021 09092021

programming-languageunix
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.