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
- 2428 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 do you go back in sql?
What is the difference between truncate and drop statements?
What is the best free sql database?
What is primary and foreign key?
What is dbo in sql?
What is string join?
What is trigger in pl sql with examples?
What is coalesce sql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
How to disable a trigger name update_salary?
Why do we go for stored procedures?
which tcp/ip port does sql server run on? : Sql dba
How do I view a view in sql?
What is update query?
What is the use of index in hive?
