i have seen in LEFT JOIN RIGHT JOIN INNER JOIN SELF JOIN

Regarding joins what are the differences you observed in
oracle 9i and sql server?

Question Posted / uma

Answer Posted / uma

i have seen in
LEFT JOIN
RIGHT JOIN
INNER JOIN
SELF JOIN

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is online transaction processing (oltp)? : Sql dba

995

i have some prob lem to tell me about my self in interview first round ...

2164

What are the different dml commands in sql?

1176

What is crud diagram?

949

How can you load multi line records? : aql loader

1076

What mean sql?

1014

What is union and union all keyword in sql and what are their differences?

1108

how to use case expression? : Sql dba

1028

Mention what does the hierarchical profiler does?

1091

Can we perform dml in function?

1068

What is synchronized subquery?

1169

How do I run a sql query in pgadmin 4?

962

What are stuff and replace function?

1084

How many unique keys can a table have?

1016

Can we use having without group by in sql?

983