How do you rank data in sql?
No Answer is Posted For this Question
Be the First to Post Answer
Which is better varchar or nvarchar?
What is database migration?
What is the difference between alter trigger and drop trigger statements?
What is union and union all keyword in sql?
What are literals in sql server?
What do you understand by pl/sql packages?
why we go for package? what are the advantages of using instead of seperate procuderes or functions
How do you update sql?
what is oracle sql,pl/sql with interfaces
What is a parameter query?
what is bulk bind
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)