i
Wells Fargo
Filter interviews by
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
Joins are used in databases to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column between them
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from th...
The main difference between 'having' and 'where' in SQL is that 'having' is used with aggregate functions, while 'where' is used with individual rows.
HAVING is used to filter groups of rows based on aggregate functions, such as COUNT, SUM, AVG, etc.
WHERE is used to filter individual rows based on specific conditions.
HAVING is applied after the GROUP BY clause, while WHERE is applied before.
Example: SELECT department, A...
Analytical functions are used in SQL to perform calculations across a set of rows related to the current row.
Analytical functions operate on a group of rows and return a single result for each row.
They can be used to calculate moving averages, running totals, rank, and percentiles.
Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), LEAD(), LAG(), SUM(), AVG().
Triggers are database objects that automatically perform an action when a specified event occurs on a particular table or view.
Triggers are used to enforce business rules, validate data, and maintain data integrity.
They can be created using SQL commands like CREATE TRIGGER.
Triggers can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.
An example of using triggers is to automatically upda...
Top trending discussions
I applied via Company Website and was interviewed in Mar 2021. There were 3 interview rounds.
Different types of risk in finance include market risk, credit risk, liquidity risk, operational risk, and legal risk.
Market risk refers to the potential for losses due to changes in market conditions, such as fluctuations in interest rates, exchange rates, or stock prices.
Credit risk is the risk of default by borrowers or counterparties, leading to potential losses for lenders or investors.
Liquidity risk is the risk o...
I applied via Campus Placement
I applied via Naukri.com and was interviewed before Aug 2019. There were 3 interview rounds.
I applied via Recruitment Consultant and was interviewed before Jun 2020. There were 3 interview rounds.
I applied via Naukri.com and was interviewed before Feb 2021. There was 1 interview round.
I applied via Recruitment Consultant and was interviewed before Sep 2020. There were 3 interview rounds.
based on 1 interview
Interview experience
based on 5 reviews
Rating in categories
Senior Software Engineer
4.9k
salaries
| ₹13.6 L/yr - ₹51 L/yr |
Financial Analyst
2.5k
salaries
| ₹2 L/yr - ₹6.5 L/yr |
Assistant Vice President
1.4k
salaries
| ₹12.2 L/yr - ₹41.3 L/yr |
Software Engineer
1.4k
salaries
| ₹9.6 L/yr - ₹31 L/yr |
Senior Financial Analyst
1.4k
salaries
| ₹3.2 L/yr - ₹9 L/yr |
JPMorgan Chase & Co.
HSBC Group
Cholamandalam Investment & Finance
Citicorp