Answer Posted / ram
select empno,ename,sal,e.deptno,dname from emp e right outer
join dept d where e.deptno=d.deptno
in abvoe query we use emp and dept table with right outer join
which produce output all records from dept table and
matched records from emp table
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is user defined stored procedures?
How does using a separate hard drive for several database objects improves performance right away?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What are the steps you should follow to start sql server in single-user mode?
How to convert numeric expression data types by assignment operations?
What are trace files?
Call by value and call by reference in procedure and function, with NOCOPY.
Why people hate cursor?
Tell about MOM Tool(Microsoft Operator Manager)?
What are entities and relationships?
What are the steps you can take to avoid “deadlocks”?
How do you delete duplicate rows in sql server?
Does any body please help me what question's have asked for SSRS in the interview?
What is an example of a foreign key?
Define constraints and give an example of their use?