Interested to Buy Any Domain ? << Click Here >> for more details...
What is Right Outer Join?
- 2 Answers
- 4520 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 |
Differences between Standby Vs No recovery?
If i am handling 150 servers then how to check the active jobs of all the servers?
What is a partitioned view?
What is recompile sql server?
Where is trigger in sql server?
How to perform key word search in tables?
Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.
1 Answers Cognizant, HCL, Value Labs,
Explain what role entity and relationship play in an ER diagram.
how to create a scrollable cursor with the scroll option? : Sql server database administration
What are the components of sql server service broker?
What is merge statement?
What is trigger in salesforce?
-
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)
