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 / arata kumar pattanaik
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
generally if n tables will n-1 joins
here 4 tables 3joins
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is “go” in t-sql? : Transact sql
What is difference between sql function and stored procedure?
How many types of primary keys are there?
Why we use stored procedure instead of query?
What is difference between rank () row_number () and dense_rank () in sql?
How can we optimize a sql query?
What is mdf ldf and ndf?
What are the advantages of sql? Explain
Why left join is used in sql?
what is the difference between blob and text? : Sql dba
What are the 3 types of behavioral triggers?
How to look at the current sql*plus system settings?
What is the clause we need to add in function body to return variable?
What is insert command in sql?
Why is theta join required?