Filter interviews by
I applied via LinkedIn
Use SQL query with GROUP BY and HAVING clause to identify and delete duplicate rows.
Use GROUP BY clause to group rows with same values
Use HAVING clause to filter out groups with count greater than 1
Use DELETE statement to remove duplicate rows
Left join is a type of join operation in SQL that returns all rows from the left table and matching rows from the right table.
Left join combines rows from two tables based on a related column between them.
If there is no match in the right table, NULL values are returned for the columns of the right table.
Example: SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id;
Primary key is a unique identifier for each record in a database table.
Primary key ensures each record in a table is unique
It can consist of one or multiple columns
Primary key values cannot be NULL
Top trending discussions
I applied via Recruitment Consultant and was interviewed in May 2021. There were 5 interview rounds.
The interview questions cover a wide range of topics including software engineering, technology, design patterns, databases, web development, and more.
The questions cover topics such as technology used, collections, streams, design patterns, dependency injection, microservices, database communication, annotations in Spring, React and JavaScript, Redux, API development, SOAP-based web services, Jenkins, Docker, producti...
posted on 5 Apr 2023
I applied via Company Website and was interviewed in Oct 2022. There were 2 interview rounds.
I applied via Campus Placement and was interviewed before Dec 2020. There were 5 interview rounds.
I applied via Referral and was interviewed before Sep 2021. There was 1 interview round.
I applied via Campus Placement and was interviewed in Apr 2021. There were 4 interview rounds.
posted on 29 Jun 2022
I applied via Referral and was interviewed before Jun 2021. There were 2 interview rounds.
We discuss about my experience and skills
I applied via Naukri.com and was interviewed before Jul 2021. There were 2 interview rounds.
Haker rank,..........,...........
I applied via Referral and was interviewed in Oct 2019. There was 1 interview round.
To convince a customer, understand their needs, build trust, provide value, and offer solutions.
Listen actively to the customer's needs and concerns
Build trust by being honest and transparent
Provide value by highlighting the benefits of your product or service
Offer solutions that meet the customer's specific needs
Address any objections or concerns the customer may have
Follow up with the customer to ensure satisfaction
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Associate
349
salaries
| ₹2 L/yr - ₹4.6 L/yr |
Team Lead
295
salaries
| ₹3 L/yr - ₹10 L/yr |
Senior Associate
280
salaries
| ₹2.3 L/yr - ₹8.5 L/yr |
Sales Executive
206
salaries
| ₹1.7 L/yr - ₹4.6 L/yr |
Senior Software Engineer
170
salaries
| ₹10.8 L/yr - ₹45 L/yr |
Airtel Payments Bank
HDFC Bank
Bandhan Bank
ESAF Small Finance Bank