数据库系统原理精品教学（吉林大学）18-web答案.pdfVIP

C H A P T E R 1 8 Data Analysis and Mining Solutions to Practice Exercises 18.1 query: groupby rollup(a), rollup(b), rollup(c), rollup(d) 18.2 We assume that multiple students do not have the same marks since otherwise the question is not deterministic; the query below deterministically returns all students with the same marks as the n student, so it may return more than n students. select student, sum(marks) as total, rank() over (order by (total) desc) a