A table T1 having 100 rows is joined with a table T2 with 50 rows without specifying the joined column in the where clause then result will have
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- There are 10 rows in Table A and 0 Rows in table B. Select * from A,B How many rows will be retrieved.
- There are 10 rows in Table A and 0 Rows in table B. If you fire the following query:
- Which of the following selects all the rows from one table whether they have corresponding matching rows in...
- which is correct about TABLE
- How many tables may be included with a join?
- Given that tables T1 and T2 contain the following rows : Table T1 : C1 C2 (5 4) (5 2) (5 5) Table T2 : C1 C...
- There should be one condition within the WHERE clause for each pair of tables being joined.
- Consider the following table structures: STUDENTS (STUDENT_ID, STUDENT_NAME, COURSE_ID, JOIN_DATE) RESULTS(...