CSC Hiring Associate Software Engineer

Company        Computer Sciences Corporation(CSC)

Website          www.csc.com

Eligibility        Any Graduates/PG

Experience     Freshers

Location         Indore, Madhya Pradesh

Computer Sciences Corporation(CSC)

Job Role: Associate Software Engineer

Job Summary :

Formulates and designs software systems, using scientific analysis and mathematical models to predict and measure outcomes and consequences of design.

Develops and directs software system testing procedures, programming, and documentation.

Translates logical designs into physical designs taking into account the target environment, performance requirements, and existing systems.

Produces detailed designs including physical data flows, file layouts, common routines and utilities, program specifications or prototypes, along with backup, recovery, and restart procedures.

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