what are aggregate and scalar functions? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
What is sqlerrd?
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
How many sql statements are used?
How would you hide a table in sql. ie the table can be only visible to its maker?
Which are the most commonly used sql joins?
What does rownum mean in sql?
How much does sql certification cost?
Why do we use procedures?
Is it possible to access the current value in a session before accessing next value?
Is sqlite good enough for production?
what is timestamp in mysql? : Sql dba
What are database links 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)