Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Hi all,
i have a table as follows
empid empname mgrid deptid
1 a 3 4
2 b 1 5
3 c 2 3
4 d 3 6
5 e 4 7

i want the output as
empname mgrname
a c
b a
c b
d c
e d

Question Posted / gunturajesh

Answers were Sorted based on User's Feedback



Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b ..

Answer / gunturajesh

select a.empname empname,b.empname mgrname from emp a,emp b
where a.mgrid=b.empid

Is This Answer Correct ?    20 Yes 2 No

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b ..

Answer / suresh babu

select t1.empname,t2.empname from emp t1,emp t2 where
t1.mgrid = t2.empid;

This query is self join,Which is display your requirement.

Is This Answer Correct ?    4 Yes 0 No

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b ..

Answer / alok narayan

1.
select empname,(select empname from e1 b
where b.empid =a.mgrid) from e1 a;

2.
select a.empname empname,b.empname mgrname from e1 a,e1 b
where a.mgrid=b.empid order by a.empname ;

Is This Answer Correct ?    0 Yes 0 No

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b ..

Answer / nanne saheb c

select e.empname,m.ename mgrname from emp e,emp m
where e.mgrid=m.empid;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Is sql open source?

0 Answers  

What is intersect?

1 Answers  

What are all types of user defined functions?

0 Answers  

Which join condition can be specified using on clause?

0 Answers  

What are the two parts of a procedure ?

6 Answers   Hi Caliber IT,

What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers   Polaris,

what is normalization? : Sql dba

0 Answers  

What is the best free sql database?

0 Answers  

What are the commands used in sql?

0 Answers  

What is a sql select statement?

0 Answers  

What does “select count(1) from tab” result?

10 Answers   IBM,

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

For more SQL PLSQL Interview Questions Click Here
Categories