10+ Snapdeal Interview Questions and Answers

I have extensive experience working on SQL and Excel.

• Proficient in writing complex SQL queries for data extraction and manipulation

• Expertise in data analysis and visualization using Excel

• Experience in creating dashboards and reports using Excel

• Familiarity with advanced Excel functions such as VLOOKUP, Pivot tables, etc.

Where clause is used to filter rows based on a condition, while having clause is used to filter groups based on a condition.

• Where clause is used with SELECT, UPDATE, DELETE statements.

• Having clause is used with GROUP BY clause.

• Where clause filters rows before grouping, while having clause filters groups after grouping.

• Where clause can use any comparison operator, while having clause can only use aggregate functions.

• Example: SELECT * FROM table WHERE column = 'value';

• Example: ...read more

SQL statements are executed in a specific order to ensure accuracy and efficiency.

• FROM and JOIN clauses are executed first to retrieve data from tables

• WHERE clause is executed next to filter the data

• SELECT clause is executed to retrieve specific columns

• GROUP BY clause is executed to group the data based on specified columns

• HAVING clause is executed to filter the grouped data

• ORDER BY clause is executed to sort the data

• LIMIT clause is executed to limit the number of rows return...read more

Different types of joins are inner join, left join, right join, and full outer join.

• Inner join returns only the matching rows from both tables

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

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

• Full outer join returns all the rows from both tables, with NULL values in the columns where there is no match

• Join types can be specified using keywords such a...read more