Sort by seems not working
Hi,
I have extracted program name, database name, number of locks on my query. And then, I would want to sort by the number of locks in descending order. However, it seems that it is not working properly. Thanks in advance for your help!
-
HI Jellou,
The common reason for such issues could be that, the datatype "locks" is string or char.
If you convert it to number before sort, then "sort" should work as expected
| number(locks) as locks
| sort by locks descRegards
Please sign in to leave a comment.
Comments
1 comment