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
- 10381 Views
- Sonata, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rao
generally if n tables will n-1 joins
here 4 tables 3joins
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / 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 |
Answer / mohan
There should be Three joins in where clause. no point of that the table "atable" is aliased twice. It will treat as two separate tables....
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rao
generally if n tables will n-1 joins
here 4 tables 3joins
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / 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 |
Answer / satya
HERE WE HAVE TOTAL NO. OF TABLE IS 3 SO NO. OF JOIN REQUIRE
IS 2
Thanks
satya
+919916174212
| Is This Answer Correct ? | 2 Yes | 2 No |
What is rownum in sql?
What is sql data?
What is trigger in pl sql?
What does closing a cursor do?
What is a ddl command?
how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.
What is dml and ddl?
Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.
Do view contain data?
Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN
What is the difference between pl and sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
