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
3113 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 primary and foreign key?

1046

What is the need of a partition key?

972

What does dml mean?

965

how is myisam table stored? : Sql dba

1036

What is cursor explain with example?

965

What is crud stand for?

985

How do I view stored procedures?

958

Is left join same as inner join?

1093

How do you drop a trigger?

967

How to display Row Number with Records in Oracle SQL Plus?

1026

how many sql dml commands are supported by 'mysql'? : Sql dba

1098

what are the difference between clustered and a non-clustered index? : Sql dba

1013

How do I access sql anywhere database?

952

What is the difference between function, procedure and package in pl/sql?

1223

Does inner join return duplicate rows?

962