7
Reply

Sort in sql server

Dipika

Dipika

Aug 1 2016 7:49 AM
264
how can i sort this no. 
Web\372\15-16 
Web\45\16-17 
Web\01\15-16 
Web\371\15-16  
 
according to this
Web\45\16-17  
Web\372\15-16
Web\371\15-16
Web\01\15-16
 
(In this 16-17 defines the year) 

Answers (7)