Explanation:First compute the base query and add all the resultant tuples to the recursively defined view relation. 2. Ranking of queries is done by which of the following ?
A. Group by
B. Order by
C. Having
D. Both a and b
Answer:A
Explanation:First compute the base query and add all the resultant tuples to the recursively defined view relation. 2. Ranking of queries is done by which of the following ?
A. Group by B. Order by C. Having D. Both a and b
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