SQL Interview Questions Deloitte

 1) SQL Query to get last 12 months data

2) How to delete the duplicate records from the table

USING ROW_NUMBER

USING SELF JOIN

3) How to achieve INNER JOIN using LEFT JOIN

4) Write  SQL query to fetch the country column starting with IN and 3rd charter should be a number