Interested to Buy Any Domain ? << Click Here >> for more details...
What is Right Outer Join?
- 2 Answers
- 4570 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 |
What are temporal tables in sql server 2016?
Explain log shipping and mention its advantages.
What is sql server programming?
What is unpivot?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
How to remove duplicate rows from table?
What is dataset and its uses
what is sql injection?
What is use of except clause? How it differs from not in clause?
What are the advantages of paper records?
two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?
How to Insert multiple rows with a single insert statement?
-
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)
