|
All, I am looking for a generic
solution to get the Alphanumeric sorting.
·
The user can request for any field to be sorted. ·
There is no specific format the alphanumeric string can follow. So that we can split using regex and split and sorted. ·
Need an efficient way. Should not degrade performance. I tried all possible collation example -- select * from test order by name collate "en_US"; Is there someone who has solved this problem with writing a function? Below are more details – Database
Table
Rows with orderby
I am expecting 1, bay1 2, bay2 10, bay10 11, bay11 -vidhya |
