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 company owns postgresql?
what is the difference between join and union? : Sql dba
Write a query to display the current date in sql?
Why do we need databases?
..........refers to the disk mirroring
What are the differences between implicit and explicit cursors?
What are the different set operators available in sql?
How long it takes to learn pl sql?
What are the limitations of sql express?
Can we delete column in sql?
What is a primary key? Explain
What is the maximum size of sqlite database?
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)