Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
3.5k views
in Technique[技术] by (71.8m points)

oracle SQL语句如何通过时间判断某个字段值是否下降?

比如 表中有字段

学生id、 时间、 成绩

想通过sql语句实现这样的视图:

学生id 时间 成绩 上次成绩 上上次成绩

条件: 总记录数不变,若不存在上次成绩返回空


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神解答

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share
...