sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)
1 7551i 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.
2 5086trans_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.
1 4611I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On
6 11425Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.
3 16171how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently
1 6043Post New Oracle SQL PLSQL Interview Questions
What is bank and its features and its types?
What is the use of test lab in test director?
What is the difference between find element and find elements?
Tell me about how you have left a position better than you found it
Why lysosomes are know as “the cleaners” of the cell waste?
Can forecast model be selected automatically?
What is the use of wordpress general setting?
What is the source of government income?
What made you decide to be a dental assistant?
What are triggers mysql?
Do we need to install sap gui on unix or linux?
how can I give more performance to some selected pages?
How test tube brush is used?
What are triggers? Why do we use them? Diff types of triggers? What are magic tables?
Can I use google sheets as a database?