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
3134 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 out parameter used for eventhough return statement can also be used in pl/sql?

1077

Can a foreign key be null?

1090

how to get a list of all tables in a database? : Sql dba

977

Can we use delete in merge statement?

1039

How to change sql*plus system settings?

1054

Define the select into statement.

1057

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4010

Does postgresql run on the cloud?

1147

How many types of primary keys are there?

1038

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1049

How do I truncate a word?

1090

Is vs as in pl sql?

985

What is the use of function in sql?

1094

Can a foreign key have a different name?

940

What information is needed to connect sql*plus an oracle server?

1028