Burger Singh Business Analyst Interview Questions and Answers

List is an ordered collection of elements while dictionary is an unordered collection of key-value pairs.

• Lists are accessed by index while dictionaries are accessed by keys.

• Lists can contain duplicate values while dictionaries cannot have duplicate keys.

• Lists are enclosed in square brackets [] while dictionaries are enclosed in curly braces {}.

• Example: list = [1, 2, 3] and dictionary = {'a': 1, 'b': 2, 'c': 3}

Window functions in SQL are used to perform calculations across a set of rows that are related to the current row.

• Window functions are used to calculate values based on a subset of rows within a larger result set.

• They allow you to perform calculations across rows that are related to the current row.

• Examples of window functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.

• Window functions are often used in conjunctio...read more