Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to maintain a fill factor in existing indexes?
what are the important architecture components of SSRS?
Why should one not prefix user stored procedures with ‘sp_’?
What are different types of statement?
How to edit table in sql server 2017?
What do you understand by the denormalisation?
What is abstracting periodical?
How to create new tables with "select ... Into" statements in ms sql server?
How would you add a section to a table?
What is difference between count (*) and count 1?
How to disconnect from a sql server using mssql_close()?
What is difference between equi join and inner join?
Explain DBCC?
How do I create a trace in sql server?
What are the properties of sub-query?
