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:However, the 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. 6. If there are n tuples in the partition and the rank of the tuple is r , then its ________ is defined as (r −1)/(n−1) .