how to start mysql server? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
Can a foreign key be a duplicate?
what is the boundary line in varrays?
What is pl sql architecture?
what is self join and how it works??
What is equi join in sql?
How to call a javascript function from pl sql?
what are the properties and different types of sub-queries? : Sql dba
How many triggers can be applied on a table?
real time applications of nullif?
What are sql functions? Describe in brief different types of sql 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
Is it mandatory for the primary key to be given a value when a new record is inserted?
Oracle (3253)
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)