Question d’entretien chez Aderant

Describe CTE and subquery execution differences; describe functional differences between RANK and DENSE_RANK.