Business Analytical Specialist Interview Questions and Answers

Rank assigns unique ranks to each distinct value, while dense rank assigns consecutive ranks to each distinct value.

• Rank leaves gaps between ranks if there are ties, while dense rank does not

• Rank(1, 2, 2, 3) would result in 1, 2, 4, 3

• Dense Rank(1, 2, 2, 3) would result in 1, 2, 2, 3

Types of join in SQL include inner join, outer join (left, right, full), cross join, and self join.

• Inner join: returns rows when there is a match in both tables

• Outer join: returns all rows from one table and matching rows from the other table

• Cross join: returns the Cartesian product of the two tables

• Self join: joins a table with itself