The interview started with a brief introduction and then moved into technical questions focused on SQL. They asked about writing queries using joins, optimizing queries, and creating stored procedures. Follow-up questions tested understanding of indexes and query performance.
Interview questions [1]
Question 1
They asked me to write a SQL query to fetch records from two tables using both INNER JOIN and LEFT JOIN, and then explain the difference in output.