Answer Posted / alok kumar samartha
The concept of joining a table with itself is called self
join or inner join.It works based on the provided join condition
example:-select e1.empno employee,e2.ename manager from emp
e1,emp e2 where e2.empno=e1.mgr;
Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What is range partitioning?
Is drop table faster than truncate?
What are all the common sql functions?
Is primary key a clustered index?
What is procedure explain with program?
What are hotfixes and patches?
how to see the create table statement of an existing table? : Sql dba
What is mutating sql table?
Whis is not false in primary key?
Is left join inner or outer?
What is the use of primary key?
What is $$ in sql?
Cite the differences between execution of triggers and stored procedures?
Is hadoop a nosql?
Explain how exception handling is done in advance pl/sql?