search

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

Run SQL query from specific months in SAP DB

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

在 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
Previous article：MySQL post-installation setup and testingNext article：MySQL post-installation setup and testing

Related articles

See more