Interested to Buy Any Domain ? << Click Here >> for more details...
What is a self join? Explain it with an example?
- 16 Answers
- 61703 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / pradeep sharma (http://www.tec
create table emp
(
empid int,
mgrid int,
empname varchar(50)
)
insert into emp values(1,2,'a')
insert into emp values(2,3,'b')
select * from emp
select e.empname as employee,d.empname as mgr from emp e
inner join emp d
on d.empid=e.mgrid
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain about normal forms?
What are the main phases of database development?
What are the three types of database design?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
explain detail about ftp in datastage?
What are data modelling techniques?
What are the three basic rules which are to be followed for the relational model of the database?
How is data stored in dbms?
Why does this query return 0?
How can I detect whether a given connection is blocked?
Explain about network model?
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).
Which data type cannot be used as a parameter in a udf?
What is dbms and its application?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
