What is a self join? Explain it with an example?
- 16 Answers
- 56571 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
What are the types of database model?
Can an extended stored procedure be called from inside a user-defined function?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
Explain about normal forms?
How to use timestamp datatypes
Explain the role of indexing in databases?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
Which data type cannot be used as a parameter in a udf?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
Explain what a database is?
What is DB Development software?
fact table and dimension table containg one to many relationship or many to one relastionship
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.
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Which four data types cannot be used as a return type from a user-defined function?
