Filter interviews by
I applied via LinkedIn and was interviewed in Aug 2022. There were 3 interview rounds.
Topic given and then discussion with time limit
Top trending discussions
I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.
Vlookup searches for a value in the first column of a range and returns a value in the same row from a specified column. Xlookup is a more powerful and flexible function that can search in any direction and return multiple results.
Vlookup searches vertically in a table and returns a value from a specified column.
Xlookup can search in any direction (horizontal, vertical, or both) and return multiple results.
Vlookup requ...
Subquery is a query nested within another query, while CTE is a temporary result set defined within a query. Both have their own use cases.
Subquery is enclosed in parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.
CTE is defined using the WITH keyword and can be referenced multiple times in a query.
CTEs are more readable and easier to maintain compared to subqueries.
Subqueries are useful when t...
Pivoting a table in SQL using case when statements
Use the CASE WHEN statement to create new columns based on specific conditions
Use the SUM or COUNT function to aggregate data in the pivoted table
Group by the remaining columns to ensure correct aggregation
Example: SELECT id, SUM(CASE WHEN category = 'A' THEN value END) AS A_total FROM table_name GROUP BY id;
Business Case Questions Based on a scenario where the company's Sales is Declining. How we can address the issue using transaction data
Gross profit is the total revenue minus the cost of goods sold.
Gross profit = Total revenue - Cost of goods sold
It represents the profit a company makes from its core business activities before deducting operating expenses.
It does not include expenses such as taxes, interest, and other non-operating costs.
Gross profit margin is calculated as (Gross profit / Total revenue) * 100%
Example: If a company has total revenue o...
I applied via Job Portal and was interviewed in Oct 2023. There was 1 interview round.
I applied via Referral and was interviewed in Sep 2023. There was 1 interview round.
I applied via Job Portal and was interviewed in Sep 2023. There were 3 interview rounds.
posted on 11 Apr 2023
I applied via Walk-in and was interviewed in Mar 2023. There were 3 interview rounds.
Hay guys how are you 😊 and where you are from and how much experience you have
posted on 12 Oct 2023
I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.
Knowledge
Feild work
Sales
Marketing
Incentive
I applied via LinkedIn and was interviewed before May 2023. There were 3 interview rounds.
Case study for business problems
Interview experience
Reliance Retail
DMart
Future Group
Vishal Mega Mart