Gallagher Trainee Interview Questions and Answers

Q1. Types of sql joins
Ans. 
SQL joins combine rows from two or more tables based on related columns, enabling complex queries and data retrieval.
• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;

• RIGHT JOIN: Returns all records from the r...read more
Answered by AI
Add your answer
Q2. What is having clause
Ans. 
HAVING clause filters records after GROUP BY, allowing conditions on aggregated data in SQL queries.
• Used in SQL to filter results of aggregate functions like COUNT, SUM, AVG.

• Example: SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 10;

• It follows the GROUP BY clause in a SQL statement.

• Allows for conditions on grouped data, unlike WHERE which filters before grouping.
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer

This is only for freshers

Q1. Tell me about yourself
Add your answer
Q2. Why do you wanna join this company?
Add your answer
Q3. Basic of reinsurance
Add your answer
Q4. Who is your role model?
Add your answer
Q5. Where do you see yourself in 5 years?
Add your answer
Q6. Are you happy with salary and working hours?
Add your answer

Q1. All the questions revolve around knowing you as a person
Add your answer

Q1. Why are you looking for a change?
Add your answer
Q2. What are your salary expectations?
Add your answer
Q3. What is your family background?
Add your answer
Q4. Tell me about yourself.
Add your answer

Q1. Why quit last job? Questions on career gap, why should we hire you? What do you know about gallagher re?
Add your answer