Is join an inner join?
No Answer is Posted For this Question
Be the First to Post Answer
Show the two pl/sql cursor exceptions.
What is the difference between functions, procedures, and packages in pl/sql?
How do I send sql query results to excel?
Can we use pl sql in mysql?
What are the advantages of normalization?
How do I copy a table in sql?
What are different joins used in sql?
How do you display "13th of November, 17 days left for month end" without hardcoding the date.
What is difference between mysql and postgresql?
How can I see all tables in sql?
What is date functions?
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
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)