Q: something like rownum

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

This sounds like it should be super simple, but I can't think how to do it using plain SQL.

I am going to display some rows, and I want to number them in the display, like using rownum, except that the number only goes up when the row has some property (I don't care if it displays or not when it doesn't go up).

To explain, imagine

	select rownum  , the_date , to_char(dates.the_date,'DY') DAY 
	from my_table
	order by the_date 

shows

	1       1-Jan-2008	TUE
	2       2-Jan-2008	WED
	3	3-Jan-2008	THU
	4       4-Jan-2008	FRI
	5       5-Jan-2008	SAT
	6       6-Jan-2008	SUN
	7       7-Jan-2008	MON
	8       8-Jan-2008	TUE

but I don't want to count the weekend. what I want to show would be the following instead

	1       1-Jan-2008      TUE
	2       2-Jan-2008      WED
	3       3-Jan-2008      THU
	4       4-Jan-2008      FRI
	        5-Jan-2008      SAT
	        6-Jan-2008      SUN
	5       7-Jan-2008      MON
	6       8-Jan-2008      TUE

Looks simple, but how to do this in plain SQL?

Feedback welcome, thanks.

Malcolm Received on Thu Apr 17 2008 - 13:26:39 CDT