What is partition in sql query?


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

Post New Answer

More SQL PLSQL Interview Questions

What is sap sql anywhere?

0 Answers  


How is pl sql different from sql?

0 Answers  


difference between oracle 8i and oracle 9i

8 Answers  


Explain the difference between cursor declared in procedures and cursors declared in the package specification?

0 Answers  


Why we use cross join?

0 Answers  






4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,


wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

3 Answers   Apollo,


What is a join?

0 Answers  


Does inner join return duplicate rows?

0 Answers  


Can we insert data into view?

0 Answers  


Does sql*plus have a pl/sql engine?

0 Answers  


what is denormalization. : Sql dba

0 Answers  


Categories