Binary SoftZone Hiring Graduate Engineer Trainee

Company        Binary SoftZone Pvt. Ltd.

Website          www.binarysoftzone.com

Eligibility        B.Tech/B.E.,MCA - Computersc

Experience     Freshers

Location         Noida

Binary SoftZone Pvt. Ltd.

Job Role: Graduate Engineer Trainee

Job Summary :

Candidate must be BE/B-Tech, MCA - 2011,2012 passout

Must have exposure on .NET & PHP Technology and C language

Must have very good communication skills.

* Candidate will work on .NET and PHP projects.

JD:

Coding

Technical code reviews

Designing and Writing Technical Specifications

Client Issue Analysis and Fixing

Good knowledge and experience of development in C++,.net, PHP.

Forward Your Resume: cv@binarysoftzone.com

Reference Id: BSZ-N-GET/2011

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