Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 8519 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is acid property in a database?
How do I run a query in pl sql developer?
What is interval partition?
How does postgresql compare to "nosql"?
What is the difference between having clause and where clause?
How can you create an empty table from an existing table?
What is the maximum database size for sql express?
How long does it take to learn pl sql?
How is data stored in sql?
how can you see all indexes defined for a table? : Sql dba
How to write a query to show the details of a student from students table whose
What is the order of sql select?
how do you know if your mysql server is alive? : Sql dba
Why do we create stored procedures & functions in pl/sql and how are they different?
What are the features of pl sql?
