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
- 10625 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
What is time based sql injection?
Is sql workbench free?
The select into statement is most often used to create backup copies of tables or for archiving records?
Can you join views in sql?
What jobs use sql?
When can we use the where clause and the having clause?
What's the difference between inner join and left join?
What is implicit cursor in pl sql?
what is dbms? : Sql dba
How does stored procedure reduce network traffic?
What is materialized view. What are different methods of refresh?
What is server name sql?
What is the starting oracle error number?
What is primary key in db?
What are triggers and its uses?
