Angel One Data Analyst Interview Questions and Answers

Q1. Joins, SQL query execution
Add your answer
Q2. Simple Sals Question - SQL
Add your answer

Q1. Questions based on the understanding of joins in sql
Add your answer
Q2. Convert row to columns using sql
Ans. 
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
Answered by AI
Add your answer

Aptitude tests + 3 Rounds

Q1. Introduction , knowledge about capital market
Add your answer

Nothing as such just basic

Q1. Joins, case when
Ans. 
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
Answered by AI
Add your answer

Hackerrank test medium difficulty

Presenting the case study which was given as a take-home assignment