BT Group Interview Questions, Process, and Tips

Q1. Diff between Union and Union All
Ans. 
Union combines and removes duplicates, Union All combines without removing duplicates.
• Union combines result sets and removes duplicates

• Union All combines result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

• Union All is faster than Union as it does not remove duplicates
Answered by AI
Add your answer
Q2. Sets and their uses in Tableau
Ans. 
Sets in Tableau are custom fields that define a subset of data based on certain conditions.
• Sets can be used to group related data together for analysis

• Sets can be created based on dimensions or measures

• Sets can be used in calculations, filters, and visualizations

• Examples: creating a set of top customers, creating a set of high-value products
Answered by AI
Add your answer
Q3. Query to find 2nd highest salary
Ans. 
Query to find 2nd highest salary in a database table
• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to retrieve the second row
Answered by AI
Add your answer
Q4. Some more basic questions
Add your answer

Given some pointers, how will I manage the stakeholders and plan.