Skip to Content
0
Former Member
Sep 19, 2008 at 01:48 PM

Retrieve the number of different occurencies in a row

40 Views

Hi experts,

Here is my problem : I have a sorted itab that looks like with vendor number that looks like that:

0000009562

0000009562

0000009562

0000009563

0000009563

0000009563

0000009563

0000009564

0000009564

I would like to retrieve the number of distinct ocurrances meaning 3.

I tried to use the SELECT COUNT dinstinct instruction but can't find the proper syntax.

Anybody can help ?

<removed_by_moderator>

Many thanks.

C.K.

Edited by: Julius Bussche on Sep 19, 2008 4:27 PM