State Forest Research Institute walk in interview for Field Assistant,Project Assistant,Oct 2012

A Walk in Interview will be held on 03-11-12 from 11.00 AM onward for the following temporary posts under externally funded projects to select suitable candidates. The selected candidates will be appointed initially for a period as per column No. 5 which may be extended as per the project requirement and subject to the satisfactory performance. Interested candidates should report at 10.00 AM on the date of Interview. Candidates will bring relevant certificates, mark sheets, works experience etc. in original along with one set of self attested photocopies and bio-data at the time of interview. No TA/DA will be admissible.

Company :State Forest Research Institute

website : www.mpsfri.nic.in
Location : Madhya Pradesh

Project Assistant 03

Field Assistant 01

others 03

Qualification: M.Sc/B.Sc

Last Date: 03-11-2012

Link for more details: http://www.mpsfri.nic.in/Recruitment.HTM

How to find out Max Salary from each department

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

List the emps who joined before 1981.

Answer: select * from emp where hiredate < (’01-jan-81’);

SQL Info

Search This Blog