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
- 10487 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
how to write date and time literals? : Sql dba
What are the types of join and explain each?
What is sql partition function?
Difference between table function and pipelined function?
Does mysql support pl sql?
What is dialect in sql?
what are different types of collation sensitivity? : Sql dba
can sql servers linked to other servers like oracle? : Sql dba
What does desc stand for?
Why do we need databases?
Is there a 64 bit version of ssms?
what is not null constraint? : Sql dba
How do I remove sql developer from windows 10?
How can I see all tables in sql?
Do foreign keys improve performance?
