How does a self join work?


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

Post New Answer

More SQL PLSQL Interview Questions

What is dynamic query?

0 Answers  


write a procedure to find top second no from a list of numbers

1 Answers   ABC,


What is the purpose of normalization?

0 Answers  


i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,


Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 Answers  






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

0 Answers  


What is nested table in pl sql?

0 Answers  


What is the difference between pl and sql?

0 Answers  


How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,


What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,


What is a temp table?

0 Answers  


Is pl sql and postgresql same?

0 Answers  


Categories