1 SELECT a.field1, b.field2, c.field3, d.field4
2 FROM atable a, atable b, ctable c, dtable d
3 ?
4 ORDER BY 1
What is the minimum number of joins that must be specified
on line 3 in the sample code above to properly link the
tables? Notice that the table "atable" is aliased twice:
once as "a" and once as "b."
1. One join
2. Two joins
3. Three joins
4. Four joins
5. Five joins
Answer Posted / rao
generally if n tables will n-1 joins
here 4 tables 3joins
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What are the advantages of indexing?
what is a join? : Sql dba
What are the benefits of pl/sql packages?
How do I use google cloud in sql?
What is the full form of sql?
What is crud stand for?
Can we alter stored procedure?
what is a composite primary key ? : Sql dba
What is fmtonly in sql?
What is pl sql package?
What are triggers and its types?
What is rownum and rowid?
How bulk collect improves performance?
What is difference between left and right outer join?