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
3208 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

Are left and right joins the same?

1157

Explain commit, rollback and savepoint.

1054

What does count (*) do in sql?

1050

Why is theta join required?

1188

Why we use joins in sql?

1036

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1630

Explain the types of joins in sql?

1073

What do you think about pl/sql?

1125

Why is stored procedure faster than query?

1021

what is uncommittable transactions? : Transact sql

1038

Can triggers stop a dml statement from executing on a table?

1158

Do we need to rebuild index after truncate?

1098

How do you exit in sql?

1159

Why is pl sql needed?

1004

What are the different set operators available in sql?

1080