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 / arata kumar pattanaik

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
generally if n tables will n-1 joins
here 4 tables 3joins

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is pl sql and postgresql same?

545


How to get each name only once from an employee table?

581


What are keys in sql?

525


What is the difference between unique and primary key constraints?

562


what are the differences between require and include, include_once and require_once? : Sql dba

496






When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

599


how many ways to get the current time? : Sql dba

510


How to pipe multiline string to isql?

548


How do I save a stored procedure?

498


What are all different types of collation sensitivity?

509


Is clustered index a primary key?

512


Name three sql operations that perform a sort.

558


When are we going to use truncate and delete?

525


Explain how exception handling is done in advance pl/sql?

526


What is the current version of postgresql?

532