Skip to Content
0
Former Member
Jul 25, 2016 at 01:02 PM

Aggregation level sql script.

59 Views

Hi,

I am pretty new to sql script in hana . I have a requirement in which i have to write a sql script on the below conditions.

Category

type

east

west

North

South

central

others

10

100

100

200

300

400

500

890

10

200

100

200

300

400

500

890

20

300

200

300

400

500

890

500

10

100

100

200

300

400

500

890

20

200

200

300

400

500

890

500

10

300

100

200

300

400

500

890

20

100

200

300

400

500

890

500

1- check for types (100, 200, 300)

2-. If type 100, read all the rates east,west,north,south,central

sum it and sent it back to some output a1

3-. If type 200 or 300, then read other... sum it and sent back to some output b1




Regards,

Richard