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
3069 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 the sql case statement?

951

What is sql exception?

913

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1045

What is %rowtype in pl sql?

923

What is normalization in sql?

962

What is cursor and why it is required?

1105

Why is nosql good?

976

Is sqlite thread safe?

991

Can 2 queries be executed simultaneously in a distributed database system?

1082

Does truncate free space?

945

What are inner outer left and right joins in sql?

964

What are the parameter modes supported by pl/sql?

1019

What are sql functions? Describe the different types of sql functions?

1057

Can we rollback after truncate?

980

What is benefit of creating memory optimized table?

907