1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all
Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

Question Posted / sudarshanbehera07@gmail.com


3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Se..

Answer / sudarshanbehera07@gmail.com

Ans: sum_1 max_1 count_1
2014 2011 3

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Does google use sql?

0 Answers  

How to run sql statements through the web interface?

0 Answers  

What is procedure explain with program?

0 Answers  

Why use stored procedures?

0 Answers  

What language is oracle sql developer?

0 Answers  




diff b/w function and procedure?

9 Answers   iFlex,

what is the difference between $message and $$message? : Sql dba

0 Answers  

Which sorts rows in sql?

0 Answers  

What are the set operators in sql?

0 Answers  

What is right join sql?

0 Answers  

What are pl sql procedures?

0 Answers  

What are basic techniques of indexing?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories