Current location - Recipe Complete Network - Catering franchise - How to write a query for help: there is table A in SQL, only column B is 1, and there are several data below: management expenses-catering expenses-sales expenses-transportation-subway.
How to write a query for help: there is table A in SQL, only column B is 1, and there are several data below: management expenses-catering expenses-sales expenses-transportation-subway.
When instr(B,'-',1, 2) >, select case0 and then substring (b, instr(B,' -')+ 1, instr(B,'-',1, 2)-/kloc-.