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
- 8530 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
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
How do I save a stored procedure?
How do I find duplicates in a single column in sql?
What are the indexing methods?
How do you use collections in procedure to return the resultset?
what is the stuff function and how does it differ from the replace function? : Sql dba
What jobs use sql?
what is acid property in database? : Sql dba
Why having clause is used in sql?
What is compute?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is pessimistic concurrency control? : Transact sql
What are inner outer left and right joins in sql?
What steps server process has to take to execute an update statement?
What is view explain with example?
