What is the difference between Union and Union all. Which is faster.


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

Post New Answer

More SQL PLSQL Interview Questions

What is auto increment in sql?

0 Answers  


Is big data nosql?

0 Answers  


What is Histogram?

0 Answers   NIIT,


What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,


What are dml commands?

0 Answers  






What is before and after trigger?

0 Answers  


7. Where would you look for errors from the database design?

1 Answers   Fintellix,


write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

0 Answers  


Which is faster view or stored procedure?

0 Answers  


What is data type in sql?

0 Answers  


Why do we use procedures?

0 Answers  


How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  


Categories