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
- 10631 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
Are subqueries better than joins?
What is java sql package?
When should I use nosql database?
What is the purpose of a secondary key?
What is nvl?
What is sql*loader and what is it used for?
What is on delete set null?
What is rank function in sql?
What is the purpose of the partition table?
What are the string functions in sql?
what is the difference between $message and $$message? : Sql dba
What is the maximum rows in csv?
explain primary keys and auto increment fields in mysql : sql dba
Write a sql select query that only returns each name only once from a table?
What is pivot in sql?
