What is the difference between having clause and where clause?
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.
how can we optimize or increase the speed of a mysql select query? : Sql dba
What is foreign key sql?
In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?
What is replication id?
What are pl sql procedures?
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
What are local and global Indexes and where they are useful.
Which type of cursor is used to execute the dml statement?
What is t sql used for?
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)