Explanation:Order by clause arranges the values in ascending or descending order where default is ascending order . 3. In rank() function if one value is shared by two tuples then
A. The rank order continues as counting numbers
B. The rank order continues by leaving one rank in the middle
C. The user specifies the order
D. The order does not change
Answer:A
Explanation:Order by clause arranges the values in ascending or descending order where default is ascending order . 3. In rank() function if one value is shared by two tuples then
A. The rank order continues as counting numbers B. The rank order continues by leaving one rank in the middle C. The user specifies the order D. The order does not change
Explanation:Example . rank() over (order by (GPA) desc). 4. The __________ function that does not create gaps in the ordering.