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
- 10629 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 can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is dml and ddl?
Can we write dml inside a function in sql server?
What is not equal in sql?
What is delete command in sql?
what are aggregate and scalar functions? : Sql dba
Does sql require a server?
How many types of sql are there?
What are the rules to be applied to nulls whilst doing comparisons?
What are the basic sql commands?
What are character functions in sql?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
Why use triggers in sql?
Why is %isopen always false for an implicit cursor?
Describe sql comments?
