 Related Questions Latest Answer : JOIN:it is nothing but a query used to retrieve data from more than two tables. ... Latest Answer : We can be selective in joins query. e.g.select e.name,d.cityfrom employee einner join detail don e.employee_id = d.employee_id and d.city in('aaa',bbbb','cccc') ... Latest Answer : UNION : It is a set operator which retrives all the matching records from two different tables and eliminates the duplicate rows.OUTER JOIN: It is used to retrive lacking records from one table against the existing records from the other table. egselect ... Join is a query which retrieves related columns or rows from multiple tables.Self Join - Joining the table with itself.Equi Join - Joining two tables by equating two common columns.Non-Equi Join Latest Answer : In Full Outer Join we get both matched and unmatched data from both the tables whereas Cartesian join is a join in which each row of one table is cross multiplied with each row of the second table ... Latest Answer : Inner jon Or equi join is The query that retrives the rows that exact match using (=) sign in where clause ... Latest Answer : It implicitly construct the join condition on the 2 tables taking all the column with same name into consideration.Natural join is also called blind join.select employee_id,last_name,department_name from employees natural join departments; ... Read Answers (3) | Asked by : rajani Latest Answer : Theta Joins Theta joins are joins that use any of the comparison operators: Greater than, denoted by > Greater than or equal to, denoted by >= Less than, denoted by < Less than or equal to, denoted by
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
