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 |
How to use subqueries with the in operators in ms sql server?
Can you give an example of Stored Procedure?
Explain Normalization and DE normalization
What is advantage data architect?
Explain triggers?
What is user-defined function?
When you should use a low fill factor?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What is the purpose of the model database?
In which year relase the 7.0& 2000 & 2005?
What are examples of triggers?
What is rolap and its advantage? : sql server analysis services, ssas
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)