BS Balance Sheet
PL Profit and Loss Before we like to see some of the conditions like grouping we shall know the existing records in raak-ledger-master
Syntax: select * from raak-ledger-master
Result:
RECORD-ID
LEDGER-CODE
LEDGER-NAME
REPORT-TYPE
- - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - - -
- - - - - - - - - - - -
1
BS-0001-00
CASH ACCOUNT
BS
2
PL-0002-00
SALES ACCOUNT
PL
3
BS-0004-00
CAPITAL ACCOUNT
BS
On seeing the above, we shall find that 'BS' found three
times and'PL' as 1 time. Now we like to have
report-type and how many records are available
14.07 How to use group by clause
Syntax: select report-type, count(*) from raak-ledger-master group by report-type ;