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 multi-statement table-value user-defined function?
Who is the owner of a schema in ms sql server?
How do I schedule a sql server profiler trace?
What are out-of-range errors with date and time literals?
Where is trigger in sql server?
What is lock escalation and what is its purpose?
What are the different types of upgrades that can be performed in sql server?
Explain user defined views?
What are indexes in ms sql server?
Explain Capacity planning to create a database? and how to monitor it?
How to access the deleted record of an event?
What is difference between order by and group by?
What is triggers and its types?
List down some advantages of sql stored procedure?
Explain unique key in sql server?