Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
No Answer is Posted For this Question
Be the First to Post Answer
Enlist the data types that can be used in pl/sql?
What is magic table?
how to rename an existing column in a table? : Sql dba
What are different functions in sql?
what are the disadvantages of mysql? : Sql dba
Define SQL and state the differences between SQL and other conventional programming Languages?
what is msql? : Sql dba
How do you know if a relationship is 2nf?
Which one is better sql or oracle?
what is the command for user data type?
Is inner join faster than left join?
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)