How can we help you today? How can we help you today?

Can I sort columns by ascending from where clause

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,  :)
bcnk
0

Comments

5 comments

Sort by
  • 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!
    PlantBasedSQL
    0
  • bcnk
    Thank you so much for your response!  I have one question... Where can i find 'Query Data' tab ?  Is that additional product ?
    bcnk
    0
  • 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!
    PlantBasedSQL
    0
  • bcnk
    Thank YOU so much :)
    bcnk
    0
  • 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!
    PlantBasedSQL
    0

Add comment

Please sign in to leave a comment.