Ans: sum_1 max_1 count

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

1 Answers
3147 Views
Fintellix, I also Faced
E-Mail Answers

Answer Posted / sudarshanbehera07@gmail.com

Ans: sum_1 max_1 count_1
2014 2011 3

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is dml and ddl?

970

Can I join the same table twice?

1057

Why procedure is used in sql?

1046

How many types of index are there?

1046

What is the difference between microsoft sql and mysql?

968

what is rollback? : Sql dba

1116

What is a primary key example?

969

How delete all data from all tables in sql?

954

Does user triggers have entry for trigger with compilation errors?

1045

What is procedure explain with program?

1028

What are the constraints available in sql?

1055

What does select * from mean in sql?

3252

What is %type in pl sql?

975

what is the difference between join and union? : Sql dba

1123

How can we store rows in PL/SQL using array?

1228