SAMCO Securities Equity Research Analyst Interview Questions and Answers

Aptitude tests + 3 Rounds

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

Q1. Result of different sql joins
Ans. 
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
Answered by AI
Add your answer

Q1. Like basic tableau and sql
Add your answer

Based on sql queries

Basic coding based on job profile

Q1. More about project
Add your answer

Q1. Salary negotiation
Add your answer