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
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is difference between unique and primary key?
Which tcl commands are available on the sql server?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What are constraints?
How can we solve concurrency problems?
Explain what are sparse columns?
Explain how would you store your query in an SSRS report or a Database server?
What is 1nf normalization form?
What are the advantages to use stored procedures?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What is the use of custom fields in report?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
Why are sql functions used?
How to create stored procedures with parameters in ms sql server?
