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


Please Help Members By Posting Answers For Below Questions

What is dense_rank in sql?

516


What are types of indexes in sql?

521


What is the difference between Union and Union all. Which is faster.

824


How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

615


Why do we use sql constraints?

616






Explain the purpose of %type and %rowtype data types?

483


What is the use of sqldataadapter?

507


what is oracle database ? : Sql dba

524


Does view contain data?

591


what is a tablespace? : Sql dba

536


What does count (*) do in sql?

501


Can you sum a count in sql?

532


What kind of join is join?

528


Is it possible to link two groups inside a cross products after the cross products group has been created?

569


How can a function retun more than one value in oracle with proper example?

558