VB.NET - query

Asked By pradeep kumar on 24-Feb-12 06:28 AM

Select Count( * ) from HolidaysList where Date not in '05-02-2012'
this query not working .... actually when sundays found then i want to restrict that date to fecthing from holidays date 
please
thank u
Somesh Yadav replied to pradeep kumar on 24-Feb-12 06:52 AM
select count(*)
  2    from ( select rownum-1 rnum
  3             from all_objects
  4            where rownum <= to_date('&1') - to_date('&2')+1 )
  5   where to_char( to_date('&2')+rnum-1, 'DY' ) 
                      not in ( 'SAT', 'SUN' )
  
Why are we adding -1 to rownum, and then adding one below
where rownum <= to_date('&1') - to_date('&2')+1 ), and then 
subtracting -1 again below
where to_char( to_date('&2')+rnum-1, 'DY' ) 
                      not in ( 'SAT', 'SUN' )
  
Thank you