Define union, minus, union all, intersect ?
No Answer is Posted For this Question
Be the First to Post Answer
i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.
2 Answers IBM, Loginworks, OFSS,
Which one is better subquery or joins?
what is subquery? : Sql dba
Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)
What mean sql?
How many types of triggers are there in pl sql?
What problem one might face while writing log information to a data-base table in pl/sql?
How to look at the current sql*plus system settings?
I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...
Can we use insert statement in function?
How many tables can you join in sql?
What is a pl/sql block?
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)