Inorder to give only 10 rank on the whole we should use :
A. Limit 10
B. Upto 10
C. Only 10
D. Max 10
Answer:A
Inorder to give only 10 rank on the whole we should use :
A. Limit 10 B. Upto 10 C. Only 10 D. Max 10
Explanation:Limit clause does not support partitioning, so we cannot get the top n within each partition without performing ranking; further, if more than one student gets the same GPA, it is possible that one is included in the top 10, while another is excluded. 4. Suppose we are given a view tot credits (year, num credits) giving the total number of credits taken by students in each year.The query that computes averages over the 3 preceding tuples in the specified sort order is :