Interested to Buy Any Domain ? << Click Here >> for more details...
What is Right Outer Join?
- 2 Answers
- 4548 Views
- I also Faced
- E-Mail Answers
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 |
When columns are added to existing tables, what do they initially contain?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
what is the system function to get current user's user id? : Sql server database administration
What is query and its types?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is the command used to get the version of sql server?
how to know Who Is Blocking Your SQL Server?
What is a rownum?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What is the difference between commit and rollback?
According to you what goes into making the best database administrator? : sql server database administration
What is query optimization process?
-
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)
