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);
Answer / sudarshanbehera07@gmail.com
Ans: sum_1 max_1 count_1
2014 2011 3
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the use of partition by in sql?
How do I run a sql query in pgadmin 4?
What is trigger in sql? Explain
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What pl/sql package consists of?
What is nested table in pl sql?
Do we need commit after truncate?
what is hash join
Why do we use sqlite?
What are the modes of parameters that can be passed to a procedure ?
How to create an array in pl/sql?
What are sql objects?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)