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
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 is a null value?
how to check server status with 'mysqladmin'? : Sql dba
What is an index in sql with example?
Which sql statement is used to delete data from a database?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What are procedures used for?
What is a data manipulation language?
How many subqueries can be nested in a statement?
What is pl sql record in oracle?
What is embedded sql with example?
What is sorting in sql?
What is posting?
What is foreign key in sql with example?
Does sql*plus have a pl/sql engine?
How to display Row Number with Records in Oracle SQL Plus?