Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 10189 Views
- Sonata, I also Faced
- E-Mail Answers
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
What is nvl?
What is pl sql record in oracle?
What is sql rowcount?
What does sign mean sql?
what is the difference between inner and outer join? Explain with example. : Sql dba
How many aggregate functions are available there in sql?
how to include comments in sql statements? : Sql dba
What is the difference between unique and primary key constraints?
What type of database is cloud sql?
What is a primary key sql?
What is sql stand for?
What is primary key in db?
What is t sql in sql server?
What is the difference between left and left outer join?
What is sql table?
