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
Is pl sql and postgresql same?
How to get each name only once from an employee table?
What are keys in sql?
What is the difference between unique and primary key constraints?
what are the differences between require and include, include_once and require_once? : Sql dba
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
how many ways to get the current time? : Sql dba
How to pipe multiline string to isql?
How do I save a stored procedure?
What are all different types of collation sensitivity?
Is clustered index a primary key?
Name three sql operations that perform a sort.
When are we going to use truncate and delete?
Explain how exception handling is done in advance pl/sql?
What is the current version of postgresql?