Interested to Buy Any Domain ? << Click Here >> for more details...
What is a self join? Explain it with an example?
- 16 Answers
- 60583 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 network model?
How can I detect whether a given connection is blocked?
explain detail about ftp in datastage?
How to replace not in with not exist?
How would you design a database for an online site, which would average a million hits a day?
What is normalization? Explain different levels of normalization?
What is database design and development?
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?
How to customize error conditions.
How to generate OIDS
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).
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.
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?
How long can an error message be in raiseerror function?
Which data type cannot be used as a parameter in a udf?
