View Count: 0
Duration: 41 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 41 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 50 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Question No: 1 of 1
Which of the following option is correct? 
Options:
  1. JOINS can be used to fetch data from multiple tables even if they do not have a common column
  2. JOINS cannot be used to fetch data from multiple tables when they do not have a common column
View Answer/Explanation:
a
Explanation:
Example1:-A CROSS JOIN or CARTESIAN JOIN does not require a common column to be present in both the tables Example2:-The following query fetches data from two tables using (Non-Equi Join) where the two tables do not have a common column Select E.Name, E.Salary, S.Grade FROM Employee e, Salgrade s WHERE E.Salary BETWEEN s.losal AND s.halis

  1