What is Right Outer Join?
Answers were Sorted based on User's Feedback
Answer / g.ramesh
It produce Result Set Which contains matched rows and right
table unmatched rows.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / 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 |
MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE
What do you mean by authentication modes in sql server?
which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM
What are transactions and its controls?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
Define DML and DCL statements?
What is database dimension? : sql server analysis services, ssas
How many levels of sp nesting is possible?
What is implicit mode in sql server?
What is change tracking in sql server?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What is meant by indexing?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)