what is the difference between where clause and having clause? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
What does the base_object_type column shows in the user.triggers data dictionary view?
Can we use view in stored procedure?
While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?
State the advatage and disadvantage of Cursor's?
Why use truncate instead of delete?
What is oracle sql called?
What are the different dml commands in sql?
What are the different dcl commands in sql?
Does oracle roll back the transaction on an error?
Whate is use of MOD function in pl/sql.
what is External tables? explain with examples
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,
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)