Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

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 ;