- One of the main advantages of OO programming is its ease of modification.
- Objects can easily be modified and added to a system there by reducing maintenance costs.
- OO programming is also considered to be better at modeling the real world than is procedural programming.
- It allows for more complicated and flexible interactions.
- OO systems are also easier for non-technical personnel to understand and easier for them to participate in the maintenance and enhancement of a system because it appeals to natural human cognition patterns.
- For some systems, an OO approach can speed development time since many objects are standard across systems and can be reused.
- Components that manage dates, shipping, shopping carts, etc. can be purchased and easily modified for a specific system.
You can find maximum salary for each department by grouping all records by DeptId and then using MAX() function to calculate maximum salary in each group or each department. SQL Query: SELECT DeptID, MAX(Salary) FROM Employee GROUP BY DeptID. This questions become more interesting if Interviewer will ask you to print department name instead of department id, in that case you need to join Employee table with Department using foreign key DeptID, make sure you do LEFT or RIGHT OUTER JOIN to include departments without any employee as well. Here is the query
Comments
Post a Comment