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...
Softwaretest Engineer
4
salaries
| ₹4.1 L/yr - ₹5.1 L/yr |
HR Generalist
3
salaries
| ₹3.6 L/yr - ₹7 L/yr |
Oracle
Yalamanchili Software Exports
MapmyIndia
Amity Software Limited