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
The qualified students of JEE Main and JEE Advanced are invited for josaa online registration 2019. The registration will be initiated by the Joint Seat Allocation Authority. Candidates can register themselves on the official website. After registration of JoSAA 2019, applicants will be able to take part in the 7 rounds of counselling and seat allotment. Thus it is mandatory for qualifiers to do JoSAA 2019 registration so as to obtain a seat in any of the 100 participating institutes.
ReplyDelete