Explanation:Percent rank of a tuple gives the rank of the tuple as a fraction. 7. Inorder to simplify the null value confusion in the rank function we can specify
A. Not Null
B. Nulls last
C. Nulls first
D. Either b or c
Answer:A
Explanation:Percent rank of a tuple gives the rank of the tuple as a fraction. 7. Inorder to simplify the null value confusion in the rank function we can specify
A. Not Null B. Nulls last C. Nulls first D. Either b or c
Explanation:select ID, rank () over (order by GPA desc nulls last) as s rank from student grades;. 8. 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