Can I sort columns by ascending from where clause

bcnk

Good morning, There is a Where Clause Options from Show Table Data.  Can I sort the selected data columns by ascending/descending order?  If so,  what is the where clause command to sort the column data by ascending / descending ?   
thank you, 

PlantBasedSQL

Hi @bcnk thank you for your post! As far as I'm aware unfortunately the Data Viewer doesn't support the sorting of Data once it has been fetched, unless you use the 'Query Data' tab specifically like this.

I hope this helps! Let me know if you have any additional questions!

bcnk

Thank you so much for your response!  I have one question... Where can i find 'Query Data' tab ?  Is that additional product ?

PlantBasedSQL

Not a problem @bcnk it's my pleasure!
If you go to Tools (at the top) > Data Viewer you should have two options, quick data and query data, as per the photo above - let me know if you have any other problems with this! 
Thank you very much!

bcnk

Thank YOU so much

PlantBasedSQL

My pleasure @bcnk - if you have the opportunity, and just for the forums so it is marked as such, could you feel free to choose a reply as an "Accepted Answer", if you're happy with the support

Thanks very much!