What is the difference between inner join and left join?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Is full outer join same as cross join?

0 Answers  


What is a constraint? Tell me about its various levels.

0 Answers  


What is execute immediate?

0 Answers  


What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,


How will you select unique values from a list of records?

7 Answers   Cap Gemini,






Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  


i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,


What are the PL/SQL Statements used in cursor processing ?

4 Answers  


How do you get column names only for a table (sql server)?

0 Answers  


What is parameter substitution in sql?

0 Answers  


What is clause in sql?

0 Answers  


I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,


Categories