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 |
How do you get column names only for a table (sql server)?
Is sql difficult?
What are the two different parts of the pl/sql packages?
what is datawarehouse? : Sql dba
please explain database architecture..
What is difference between select statement and cursor
In packages the source code is compiled into p code ? how do we describe the p code
How can i insert data inro a table with 3 columns using FORALL?
What is sql analyzer?
Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?
how to analyze tables with 'mysqlcheck'? : Sql dba
What is difference between primary and secondary key?
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)