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
- 10379 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / rao
generally if n tables will n-1 joins
here 4 tables 3joins
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Can we join same table in sql?
What has stored procedures in sql and how we can use it?
Can we call stored procedure in function?
how to include comments in sql statements? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is mutating table error?
What is sql mysql pl sql oracle?
What are the ways on commenting in a pl/sql code?
What does truncate mean in sql?
What is the purpose of a sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is rownum and rowid?
What do you mean by “trigger” in sql?
What is the difference between count 1 and count (*) in a sql query?
What is normalization? How many normalization forms are there?
