How many types of Outer Joins?What are they?
Answer / g.ramesh
We have 3 Types of Outer Joins.
1.Left Outer Join
2.Right Outer Join
3.Full Outer Join
| Is This Answer Correct ? | 12 Yes | 0 No |
Give an example of why you would want to denormalize a database
How can I track the changes or identify the latest insert-update-delete from a table?
What is pivot and unpivot?
Explain the usage of floor function in sql server.
How can we rewrite sub-queries into simple select statements or with joins?
Explain left outer join and right outer join?
What is implicit cursors?
What are the benefits of filtered indexes?
What is normalization process?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is update locks?
How to check if stored procedure is running in sql server?
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)