What are the different types of triggers?
- 0 Answers
- 773 Views
- I also Faced
- E-Mail Answers
Why do we use joins in sql?
Which data dictionary views have the information on the triggers that are available in the database?
How do we tune the code?
What is difference between db2 and sql?
Why truncate is used in sql?
How many clustered indexes can be created on a table?
Write a query to display the current date in sql?
what is the difference between where clause and having clause? : Sql dba
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. pls give me answer. i want urgent
What does an inner join do?
What is not equal in sql?
Describe sql comments?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
