Welcome To Ask or Share your Answers For Others

How to display data in a range data based on transaction type using SQL?

asked Jan 25, 2021 in Technique[技术] by 深蓝 (71.8m points)

How to display data in a range data based on transaction type using SQL?

Our data table looks like this:

Machine Name	Action	Date
M123	Work	01/12/2021
M123	Maintained	01/12/2021
M741	Work	01/05/2021
M123	Maint Req	01/04/2021
M951	Work	12/29/2020
M123	Maintained	11/15/2020
M123	Work	11/15/2020
M123	Work	11/15/2020
M123	Maint Req	11/15/2020

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

Welcome To Ask or Share your Answers For Others

1 Answer

...