What is difference between inner join and self join?


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

Post New Answer

More SQL PLSQL Interview Questions

Which one is better sql or oracle?

0 Answers  


how to show all tables with 'mysql'? : Sql dba

0 Answers  


What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,


How to find last day of the month in sql query

4 Answers  


What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,






How many clustered indexes can be created on a table?

0 Answers  


What is column?

0 Answers  


What is differance unique key and primary key.

7 Answers   EDS,


Is pl sql and postgresql same?

0 Answers  


What is integrity constraints?

5 Answers   Ramco, Satyam,


I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.

1 Answers  


How many developers work on postgresql?

0 Answers  


Categories