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);
- 1 Answers
- 2727 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
How many sectors are in a partition?
What is self-join and what is the requirement of self-join?
Can we write ddl statements in functions?
What is the file extension for sql database?
What is sql and explain its components?
explain what is mysql? : Sql dba
How does one load ebcdic data? : aql loader
How to use sql*plus built-in timers?
Does db2 use sql?
What is the benefit of foreign key?
What is the difference between alter trigger and drop trigger statements?
What is bitemporal narrowing?
how many groups of data types? : Sql dba
What are transaction and its controls?
when MSQL8.0 is in market
