Which is better cte or subquery?


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

Post New Answer

More SQL PLSQL Interview Questions

select 1,col1,col2 from table1. output?

5 Answers   Ramco,


Explain about various levels of constraint.

0 Answers  


What is rowid in sql?

0 Answers  


How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,


Can we update views in sql?

0 Answers  






What does over partition by mean in sql?

0 Answers  


IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,


Write a query to get last 10 records from the table.

12 Answers   iNautix,


write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  


What is use of package in pl sql?

0 Answers  


what are the advantages of sql ? : Sql dba

0 Answers  


What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,


Categories