Zamil ITG Interview Questions and Answers

Joins in SQL are used to combine data from two or more tables based on a related column.

• Inner join returns only the matching rows from both tables

• Left join returns all rows from the left table and matching rows from the right table

• Right join returns all rows from the right table and matching rows from the left table

• Full outer join returns all rows from both tables, with NULL values for non-matching rows

• Cross join retur

Given an array of integers, find a contiguous subarray with a given sum.

• Use a sliding window approach to iterate through the array and keep track of the current sum.

• If the current sum exceeds the given sum, move the window's left endpoint forward.

• If the current sum is less than the given sum, move the window's right endpoint forward.

• If the current sum equals the given sum, return the subarray.

• Time complexity: O(n), Spa