Home  >  Article  >  Database  >  Run SQL query from specific months in SAP DB

Run SQL query from specific months in SAP DB

王林
王林forward
2023-08-30 13:53:101122browse

在 SAP DB 中从特定月份运行 SQL 查询

When your T0.name is a character archive, you should replace Order By -

order by
case when cast(left (T0.Name,2) as int)>=8
   then cast(left (T0.Name,2) as int)-8
   else cast(left (T0.Name,2) as int)+4
 end
as follows

The above is the detailed content of Run SQL query from specific months in SAP DB. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete