Sql - Interview Questions and Answers for 'Cogent infotech corp' | Search Interview Question

Sql - Interview Questions and Answers for 'Cogent infotech corp' - 4 question(s) found - Order By Newest

Q1. Difference between Inner and Outer Join ?

Ans. Inner join is the intersection of two tables on a particular columns whereas Outer Join is the Union of two tables.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql joins inner join outer join Asked in 4 Companies basic frequent}

Q2. What is Left Outer Join ?

Database

Ans. It returns all the rows form the left table and matches the rows in both tables.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database database joins left outer join sql Asked in 2 Companies}

Q3. Difference between Left and Inner Join ?

SQL

^{This question was recently asked at 'Canopy Tax,Cogent Infotech Corp'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql Asked in 2 Companies}

Q4. create an SQL query across multiple tables involving outer joins

Ans. Select * from table1 t1Left outer join table2 t2 on t1.tid = t2.id

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql query database outer joins Asked in 2 Companies}

Search Interview Questions