Interested to Buy Any Domain ? << Click Here >> for more details...
What is a self join? Explain it with an example?
- 16 Answers
- 61241 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
Why does this query return 0?
Explain about the database management systems.
What is an application role and explain a scenario when you would use one?
Explain the role of indexing in databases?
Write short notes on manual refreshes.
Explain the process of the user request and data generating?
How long can an error message be in raiseerror function?
Explain about query and reporting.
What is normalization? Explain different levels of normalization?
How can I detect whether a given connection is blocked?
Explain the rollup operator?
How to customize error conditions.
explain detail about ftp in datastage?
Explain about relational database management systems?
What is a database development?
