Explain what is an index?
No Answer is Posted For this Question
Be the First to Post Answer
Can you select everything, but 1 or 2 fields, without writer's cramp?
Is nosql faster than sql?
How can one get sql*loader to commit only at the end of the load file? : aql loader
what happens if you no create privilege in a database? : Sql dba
How do I save the results of sql query in a file?
How does a trigger work?
what are aggregate and scalar functions? : Sql dba
What are system versioned tables?
what is the different between unique+not null & primary key,
When would you denormalize?
8 Answers MBT, Microsoft, MMU,
i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.
How do you update a value in sql?
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)