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
- 10472 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / rao
generally if n tables will n-1 joins
here 4 tables 3joins
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
what is a table in a database ? : Sql dba
What is the trigger in sql?
Is there any restriction on the use of union in embedded sql?
Is the primary key an index?
What is sql and explain its components?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is restrict in sql?
What are the basic techniques of indexing?
Why do we use triggers?
Why select is used in sql?
What are literals in sql server?
What is the primary use of normalization?
Can cursors be part of a trigger body?
Why should I use postgresql?
What is faster join or subquery?
