Closed ItUrri closed 1 year ago
SELECT seq, REPLACE(SUBSTR(seq, LOCATE("/", seq)+4),"-",".") as s1, CAST(REPLACE(SUBSTR(seq, LOCATE("/", seq)+4),"-",".") AS FLOAT) as s2 FROM orders order by s2 desc, s1 desc
orders
SELECT seq, REPLACE(SUBSTR(seq, LOCATE("/", seq)+4),"-",".") as s1, CAST(REPLACE(SUBSTR(seq, LOCATE("/", seq)+4),"-",".") AS FLOAT) as s2 FROM
ordersorder by s2 desc, s1 desc