Question
Perform the following queries using SQL for the relations of part(i):
- Find the list of the account holders whose account balance is less than Rs.1000/-
- Find the details of those account holders who have withdrawal nore than Rs.1,00,000/- in the last month.
- Find the sum of deposits that has been credited in each account in the last year.
- Find an account holder who has not withdrawn any money in the last year.
Answer :
Word Count : 55
________ ___ ________ ___ ____ ______ __________ ________.
_________ ____ ______ _________ _____.
________ _______ ___ ______ ___ ___ ___ __________.
____ ____ ____ _______ _____ __________ __________ ______ ____.
________ ______ ____ ____ _________ _________ _________.
__________ _________ __________.
Skip in 10
The statement is used to change a value in a table without effecting other value.
_________ ____ ______ _________ _____.
________ _______ ___ ______ ___ ___ ___ __________.
____ ____ ____ _______ _____ __________ __________ ______ ____.
________ ______ ____ ____ _________ _________ _________.
__________ _________ __________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.