Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3068 Views
- Fintellix, I also Faced
- E-Mail Answers
Answer / sudarshanbehera07@gmail.com
Ans: sum_1 max_1 count_1
2014 2011 3
| Is This Answer Correct ? | 1 Yes | 0 No |
how tsql statements can be written and submitted to the database engine? : Transact sql
what is the difference between implicit and explicit trigger
how to get @@error and @@rowcount at the same time? : Sql dba
What is foreign key in sql with example?
what the meaning of sql
if a string is there like s1,s2,s3,s4.How to find count of commas in this.
What are the types of records?
Why does %isopen return false for an implicit cursor?
What is a REF CURSOR? Compare strong and week ref cursor types.
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
How to run sql statements through the web interface?
Are there any features that are decommissioned in 11g that are not present in 11g?
-
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)
