What is Right Outer Join?
- 2 Answers
- 3493 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 is clustered vs nonclustered index?
What is master database? : SQL Server Architecture
How is table type constraint applied to a table?
How would you use user_constraints table in DB?
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...
7 Answers ADP, Satyam, Tech Mahindra,
What is a trigger?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What types of replication are supported in sql server?
Explain the creation and execution of a user-defined function in the sql server?
What is a print index?
What the different types of Replication and why are they used?
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
