User Answers - GeekInterview.com

Home

Answered Questions

Asked By: vital_parlsey | Asked On: Mar 1st, 2012

Hi, i have 3 files each having 2 cols e.G file1 empid deptid 1 100 2 200 3 200 4 100 5 300 file2 empid salary 1 10 2 20 3 30 4 40 5 ...

Answered by: PLMS on: Mar 29th, 2013

Step 1: File1 - left outer Join {Key- empid} with -File2 Step 2: The above output flow should be sort{PBKS-if multifile} based on key empid Step 3: The step 2s o/p flow to be left outer joi...

Answered by: Malini on: Apr 3rd, 2012


Code
  SELECT C.DEPTNAME,sum(B.SALARY) FROM FILE1 A ,FILE2 B ,FILE3 C
  WHERE A.EMPLID=B.EMPLID AND A.DEPTID=C.DEPTID
  GROUP BY C.DEPTNAME

User Panel

Lost Password

Get Activation Code

Interview Coaching

What are the career opportunities available for MCA Graduates?

Describe a time when you had to work under pressure.

Describe a time when you had to listen to someone.

What was the most important decision you ever had to make?

What is your way of building rapport with a person you just met?

What are the career options available in Software Testing Industry?

Describe a time when you had to convince a friend ?

How do you approach a problem?

Importance of an MBA for an entrepreneur

How to handle academic gap while applying for a job?

User Panel

Categories

Interview Coaching

Interview Question

Career Counselling

GeekInterview

Popular Sections