What does partition by mean in sql?
No Answer is Posted For this Question
Be the First to Post Answer
How long does it take to learn pl sql?
What is primary key and unique key?
Write the order of precedence for validation of a column in a table ?
how to shut down the server with 'mysqladmin'? : Sql dba
How does cross join work in sql?
Why do we use procedures in pl sql?
write a qurey for finding the length of the sting.
How do I save the results of sql query in a file?
What is cursor in pl sql with examples?
What is right join in sql?
what is the command for user data type?
Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy
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)