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
- 10373 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / sss
We need minimum of n-1 joins to join n tables.
here 3 tables are there.
so we need minimum of 2 joins to join the 3 tables
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Can a trigger call a stored procedure?
What are the main features of cursor?
Can you join a table to itself?
What is sql keyword?
What trigger means?
How do temporal tables work?
Which one is better sql or oracle?
How many types of triggers are there in pl sql?
What are the three forms of normalization?
What is input buffer in sql*plus?
what is an index? : Sql dba
What are the types of operators available in sql?
What is difference between nchar and nvarchar?
What is the use of non clustered index?
What is example of database?
