Groww Business Analyst Interview Questions and Answers

Use SQL pivot function to convert rows to columns

• Use the PIVOT function in SQL to convert rows into columns

• Specify the columns you want to pivot on and the values you want to display in the new columns

• Example: SELECT * FROM table_name PIVOT (MAX(value_column) FOR pivot_column IN (column1, column2, column3)) AS alias_name

SQL joins combine data from two or more tables based on a related column between them.

• Inner join returns rows that have matching values in both tables

• Left join returns all rows from the left table and the matched rows from the right table

• Right join returns all rows from the right table and the matched rows from the left table

• Full outer join returns all rows when there is a match in either left or right table

Joins are used to combine rows from two or more tables based on a related column between them. Case when is a conditional statement used to perform different actions based on different conditions.

• Joins are used to retrieve data from multiple tables based on a related column

• Case when is used to perform different actions based on different conditions in SQL queries

• Example: SELECT * FROM table1 JOIN table2 ON table1.id = ...read more