jeffnation
New member
- Local time
- Today, 22:16
- Joined
- Aug 5, 2021
- Messages
- 1
Hey all,
I'm having issues exporting a sorted query as a delimited text file.
I have 3 columns:
I've tried to apply the ORDER BY clause in SQL view but it has no effect.
"ORDER BY Column3 DESC;"
It only works when I tick 'export data with formatting and layout' but I need text separated with single quotes.
Any ideas?
Thanks,
Jeff
I'm having issues exporting a sorted query as a delimited text file.
I have 3 columns:
- column 1 not sorted
- column 2 not sorted
- column 3 sorted DESC
I've tried to apply the ORDER BY clause in SQL view but it has no effect.
"ORDER BY Column3 DESC;"
It only works when I tick 'export data with formatting and layout' but I need text separated with single quotes.
Any ideas?
Thanks,
Jeff