Interested to Buy Any Domain ? << Click Here >> for more details...
What is a self join? Explain it with an example?
- 16 Answers
- 61238 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vijayan.t
A table join to itself is known as self join.
select e1.empid,e1.empname,e1.empmgrname where empmgrid =
empid;
here in a single table e1 having three fields(employee id,
employee name,manager id)one employee's manager id is
another one employee's employee id so compare that 2 ids and
we can get the particular employee's manager name...
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
In which table collections errors are stored.
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Explain the cube operator?
How to replace not in with not exist?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
Write the fastest query to find out how many rows exist in a table?
How to use online Backups?
Explain about network model?
How is data stored in dbms?
Explain about relational operator join?
explain detail about ftp in datastage?
Explain about xml databases?
What are the types of database model?
Explain about the storage and physical database design?
Explain about the hierarchical model of the database?
