SQL1

select *
  from (select e.id, count(1) over(partition by 1)
          from eis_users e
         order by id)
 where rownum < 10

 

 

     -- condition for SSO_creation_status
              ((in_SSO_creation_status is null) or
              (in_SSO_creation_status = 'ALL') OR
              (in_SSO_creation_status is not null and
              in_SSO_creation_status <> 'ALL' and
              JOINREQSTATUSID = in_SSO_creation_status))