Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
163 views
in Accounting System Using Database Management System by (15.2k points)

Briefly explain the set of SQL statements to produce the receipts side of a cash book for ModeII.

Please log in or register to answer this question.

1 Answer

0 votes
by (15.7k points)

The following series of SQL statement retrieve a record set for producing the receipts side of cash book for ModeII.

1. To find the total amount by which the cash account is debited. In order to ascertain the total amount by which every transaction cash account has been debited, the following SQL statement is formed.

This SQL statement gives the code and amount from which cash is received. This SQL statement is saved as Query Cl.

2. To generate the total of Receipt side. The following SQL Statement is formed.

This SQL statement is save as Query C2.

3. To find the record set which consist of account code, Name of account, credit amount and date. The following SQL statement is formed.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...