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
- 10207 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
Mention what is the use of function "module procedure" in pl/sql?
what is union, minus and interact commands? : Sql dba
What are the types of keys?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
what is isam? : Sql dba
Write an sql query to select all records from the table?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Explain the uses of database trigger.
What is embedded sql with example?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is normalisation in sql?
What is varchar sql?
Why is sharding used?
Is join same as left join?
Is sql a programming?
