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
posted on 5 Apr 2023
I applied via Company Website and was interviewed in Oct 2022. There were 2 interview rounds.
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...
I applied via Recruitment Consultant and was interviewed in Oct 2020. There were 5 interview rounds.
Banks earn money through various sources such as interest on loans, fees, investments, and trading.
Interest on loans
Fees (e.g. account maintenance fees, ATM fees, overdraft fees)
Investments (e.g. stocks, bonds, mutual funds)
Trading (e.g. foreign exchange, commodities)
Credit card interest and fees
I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.
Luca Pacioli is considered the father of modern accounting.
Luca Pacioli was an Italian mathematician and Franciscan friar who wrote the first book on double-entry accounting in 1494.
He is known for his contributions to the development of accounting as a profession.
Pacioli's book, Summa de Arithmetica, Geometria, Proportioni et Proportionalita, included a section on bookkeeping that introduced the concept of double-entr...
I applied via Campus Placement and was interviewed before May 2021. There were 3 interview rounds.
Maths, reasoning, English, customer service
I applied via Campus Placement and was interviewed before Nov 2021. There were 3 interview rounds.
Unemployment and politics related.
Schooling and educational system.
I applied via Walk-in and was interviewed before Jan 2021. There were 4 interview rounds.
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
277
salaries
| ₹2.6 L/yr - ₹8.5 L/yr |
Sales Executive
175
salaries
| ₹1.7 L/yr - ₹4.6 L/yr |
Junior Manager
165
salaries
| ₹4.5 L/yr - ₹13 L/yr |
Airtel Payments Bank
HDFC Bank
Bandhan Bank
ESAF Small Finance Bank