What is sql trigger example?
No Answer is Posted For this Question
Be the First to Post Answer
What is latest version of sql?
How many clustered indexes can be created on a table?
What is pl sql block structure?
how to use in conditions? : Sql dba
How can we overcome recursive triggers in SQL?
How do you write a complex sql query?
what are the different types of joins?
Why we use triggers in mysql?
How can you know that statistics should be updated?
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_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.
What is schema in sql?
Define sql delete statement.