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
- 10626 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 ? | 3 Yes | 2 No |
Post New Answer View All Answers
What does the sign mean in sql?
What jobs use sql?
What is pl sql script?
How to take user input in pl sql?
What are the different operators available in sql?
what is the difference between a local and a global temporary table? : Sql dba
Why stored procedure is better than query?
Why do we use procedures?
Which constraints we can use while creating database in sql?
What is difference between function and trigger?
Why do we use sqlite?
Is null operator in sql?
What is Difference Between Unique and Primary Key Constraints?
What are the subsets of sql?
What is the requirement of self-join?
