i
SAP
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Be the first one to contribute and help others!
I appeared for an interview in Feb 2017.
I appeared for an interview before May 2016.
I appeared for an interview in Feb 2017.
Normalization to BCNF ensures that every non-trivial functional dependency is satisfied.
Identify all functional dependencies
Eliminate partial dependencies
Eliminate transitive dependencies
Ensure every determinant is a candidate key
HAVING clause is used with GROUP BY to filter groups, WHERE clause is used to filter rows.
HAVING clause is used with GROUP BY clause to filter groups based on aggregate functions.
WHERE clause is used to filter rows based on conditions.
HAVING clause is used after GROUP BY clause, while WHERE clause is used before GROUP BY clause.
HAVING clause can use aggregate functions, while WHERE clause cannot.
Example: SELECT categor...
Software Developer
1.2k
salaries
| ₹8 L/yr - ₹32.1 L/yr |
Developer
864
salaries
| ₹10.2 L/yr - ₹34 L/yr |
Developer Associate
850
salaries
| ₹6 L/yr - ₹20 L/yr |
Senior Developer
535
salaries
| ₹16 L/yr - ₹50 L/yr |
Business Process Consultant
433
salaries
| ₹10 L/yr - ₹40 L/yr |
Oracle
SAS
Zoho
IBM