Filter interviews by
The main difference between 'having' and 'where' in SQL is that 'having' is used with aggregate functions to filter groups, while 'where' is used to filter rows.
HAVING is used with GROUP BY to filter groups based on aggregate functions results
WHERE is used to filter rows based on conditions
HAVING is applied after GROUP BY, while WHERE is applied before GROUP BY
Example: SELECT department, AVG(salary) FROM employees...
Different types of joins in SQL are inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is a match in both tables
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched rows from the left table
Full outer join: Returns rows when there is a match in either table
Compare record count of 2 score files and print if they are equal or not.
Read both score files
Count the number of records in each file
Compare the record counts
Print if they are equal or not
Query to generate state-wise sales summary report with ranking using multiple table joins.
Use SQL JOINs to combine sales, states, and products tables.
Aggregate sales data using SUM() function grouped by state.
Use RANK() or DENSE_RANK() to rank states based on total sales.
Example SQL: SELECT state, SUM(sales) AS total_sales, RANK() OVER (ORDER BY SUM(sales) DESC) AS sales_rank FROM sales_data JOIN states ON sales_d...
What people are saying about PwC
Query to retrieve all customer names starting with A.
Use the SELECT statement to retrieve customer names.
Use the LIKE operator with the pattern 'A%' to match names starting with A.
Specify the table and column name where the customer names are stored.
Example: SELECT customer_name FROM customers WHERE customer_name LIKE 'A%';
Char is fixed length while varchar is variable length.
Char takes up the same amount of space for each value, while varchar only takes up as much space as needed.
Char is faster for fixed length data, while varchar is more flexible for variable length data.
Example: char(10) will always take up 10 characters, while varchar(10) will only take up as much space as needed for the value.
Example: char is commonly used for ...
Substring is a part of a string that is smaller in length and extracted from the original string.
Substring is a sequence of characters within a string.
It can be extracted using string slicing or substring functions.
For example, 'hello world'[0:5] will return 'hello'.
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a database into smaller, more manageable tables
Each table should have a primary key that uniquely identifies each record
Data is then organized into related tables to minimize redundancy
Normalization helps to prevent data inconsistencies and anomalies
There are different ...
SQL is a programming language used for managing and manipulating relational databases. NoSQL is a non-relational database management system. RDBMS is a type of DBMS that stores data in a structured format.
SQL (Structured Query Language) is used to manage and manipulate data in relational databases.
Examples of SQL commands include SELECT, INSERT, UPDATE, and DELETE.
NoSQL databases are non-relational and do not use ...
Behavioural Tests,Quants, basic Excel functions
What do you think about electric cars
I appeared for an interview in Sep 2024.
Good questions on power bi
Duration 45 min with current affairs topics
I applied via Approached by Company and was interviewed in Mar 2024. There was 1 interview round.
SQL is a programming language used for managing and manipulating relational databases. NoSQL is a non-relational database management system. RDBMS is a type of DBMS that stores data in a structured format.
SQL (Structured Query Language) is used to manage and manipulate data in relational databases.
Examples of SQL commands include SELECT, INSERT, UPDATE, and DELETE.
NoSQL databases are non-relational and do not use SQL. ...
Logical , Reasoning questions
2 program questions of Dsa
I applied via Recruitment Consulltant and was interviewed in Jan 2023. There were 4 interview rounds.
Good communication skills Strongly time management
I applied via Approached by Company and was interviewed in Oct 2022. There was 1 interview round.
I applied via Referral and was interviewed before Dec 2022. There were 4 interview rounds.
I am a data analyst with a strong background in statistics and programming.
I have a Bachelor's degree in Statistics and have completed several courses in data analysis and programming.
I have experience working with large datasets and using statistical software such as R and Python.
I have successfully analyzed data to identify trends, patterns, and insights that have helped inform business decisions.
I am skilled in data...
I want to join PwC because of their reputation for excellence in data analysis and their commitment to professional development.
PwC is known for its expertise in data analysis and has a strong reputation in the industry.
I am impressed by PwC's commitment to professional development and continuous learning opportunities.
PwC's diverse client base will provide me with exposure to a wide range of data analysis projects.
I b...
We were given a case study to solve. End-to-end. Tableau/Power BI. 3hrs
I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.
Pretty easy , questions were mostly around SQL coding
Some of the top questions asked at the PwC Data Analyst interview -
based on 10 interview experiences
Difficulty level
Duration
based on 54 reviews
Rating in categories
Senior Associate
19.2k
salaries
| ₹12.5 L/yr - ₹25.3 L/yr |
Associate
15.3k
salaries
| ₹8 L/yr - ₹14 L/yr |
Manager
7.7k
salaries
| ₹23 L/yr - ₹41 L/yr |
Senior Consultant
4.9k
salaries
| ₹16 L/yr - ₹26.5 L/yr |
Associate2
4.7k
salaries
| ₹7.5 L/yr - ₹14 L/yr |
Deloitte
Ernst & Young
Accenture
TCS