Internal Table with Group By

1 Group by with Internal table.

 

 

SFLIGHT table records.

2.jpg

 

SAMPLE CODE- that displays all records

3.jpg

OUTPUT

4.jpg

SAMPLE CODE WITH GROUP BY- it forms a group with key as CARRID

5.jpg

OUTPUT

6.jpg

SAMPLE CODE 

7.jpg

OUTPUT

10.jpg

SAMPLE CODE WITH GROUP BY - MULTIPLE COLUMNS- Forms a group with two fields/columns

8.jpg

OUTPUT

9.jpg

SAMPLE CODE- ACCESSING GROUP MEMBERS

11

OUTPUT

12

SAMPLE CODE- ACCESSING GROUP MEMBERS- MULTIPLE COLUMN FORM THE GROUP

13

OUTPUT

14

SAMPLE CODE- WITH GROUP BY YOU CAN DEFINE ALL GROUP KEYS INTO ONE

15

OUTPUT - HERE THE STRUCTURE KEY IS ONLY HAVING TWO FIELDS - KEY1 & KEY2

16


 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s