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 / satya
HERE WE HAVE TOTAL NO. OF TABLE IS 3 SO NO. OF JOIN REQUIRE
IS 2
Thanks
satya
+919916174212
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is dense_rank in sql?
What are types of indexes in sql?
What is the difference between Union and Union all. Which is faster.
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
Why do we use sql constraints?
Explain the purpose of %type and %rowtype data types?
What is the use of sqldataadapter?
what is oracle database ? : Sql dba
Does view contain data?
what is a tablespace? : Sql dba
What does count (*) do in sql?
Can you sum a count in sql?
What kind of join is join?
Is it possible to link two groups inside a cross products after the cross products group has been created?
How can a function retun more than one value in oracle with proper example?