Analysis of Group Statistics in Data Searching
Xia Haijing · Computer Knowledge and Technology · 2011
Data seraching is the most important functions of the database system,and the ultimate goal,but when users use clause of GROUP BY,clause of COMPUTE BY to achieve group statistics in data table,it often occurs syntax errors,and confuses two clauses.After the study,it analyzes the links and differences between the two,and applicable in different situations,it can help the proper use of two clauses,and it can help realy achieveing group statistics in data table.