name  surname
dimis   Miles
pavlos  Kramnik 

count   name  surname
 1      dimis   Miles
 2      pavlos  Kramnik
 3      nikos   karpow

SQL> with test as
  2    (select 'dimis' name from dual
  3     union
  4     select 'pavlos' name from dual
  5     union
  6     select 'nikos' name from dual
  7    )
  8  select rownum, name from test
  9  order by name;

    ROWNUM NAME
---------- ------
         1 dimis
         2 nikos
         3 pavlos

SQL>

SQL> WITH test AS
  2        (SELECT 'dimis' name FROM dual
  3         UNION
  4         SELECT 'pavlos' name FROM dual
  5         UNION
  6         SELECT 'nikos' name FROM dual
  7        )
  8  SELECT row_number() over (ORDER BY name) rn, name
  9  FROM test;

        RN NAME
---------- ------
         1 dimis
         2 nikos
         3 pavlos