Data Analyst and Team Lead

Data Analyst and Team Lead Interview Questions and Answers

Updated 7 Jul 2025

Asked in Paytm

3d ago

Q. 1. Types of joins : i) Scenario of 2 tables and output rows of those cases

Ans.

Types of joins in SQL include inner join, left join, right join, and full outer join.

  • Inner join: Returns rows when there is a match 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 rows when there is a match in either table.

  • Example: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.i...read more

Asked in EXL Service

4d ago

Q. How do you delete duplicate rows in SQL?

Ans.

Use the DELETE statement with a self-join to remove duplicate rows in SQL.

  • Use a self-join to identify duplicate rows based on a unique identifier column

  • Use the DELETE statement with the self-join condition to remove the duplicates

  • Example: DELETE FROM table_name WHERE id NOT IN (SELECT MIN(id) FROM table_name GROUP BY column1, column2)

Asked in Paytm

2d ago

Q. What are the differences between window functions?

Ans.

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

  • Window functions operate on a set of rows related to the current row

  • They can be used to calculate running totals, moving averages, rank, etc.

  • Examples include ROW_NUMBER(), RANK(), LAG(), LEAD()

Are these interview questions helpful?

Interview Experiences of Popular Companies

Paytm Logo
3.2
 • 800 Interviews
View all
interview tips and stories logo
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary

Data Analyst and Team Lead Interview Questions
Share an Interview
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+

Reviews

10L+

Interviews

4 Cr+

Salaries

1.5 Cr+

Users

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.

Follow Us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter
Profile Image
Hello, Guest
AmbitionBox Employee Choice Awards 2025
Winners announced!
awards-icon
Contribute to help millions!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos
Add office benefits
Add office benefits