CodePudding user response:

As group by
Select sum (bus number), avg (on time) from the table group by on site

CodePudding user response:

The select trunc (UPZD) as lh-zd,
Count (UPZD) as rs,
Avg (BOARDING_INTERVAL) as PJSCSJ
From the table
Group by trunc (UPZD)

CodePudding user response:

Sorry I didn't fully posted the whole list and not clearly stated, the question should be: will be the same and XFSJ UPZD field numerical field numerical adjacent records to carry on the summary, and XFSJ field numerical non-adjacent record summary, other problems are similar to this post: http://bbs.csdn.net/topics/392297853, thank you master, first problem solving points after