sábado, 23 de mayo de 2020

SQL FUNDAMENTALS ROWNUM



select employee_id from hr.employees
where rownum <= 50
order by employee_id;

select rowid,rownum,employee_id from hr.employees
where rownum <= 5
order by employee_id;

select rowid,rownum,employee_id from hr.employees
where rowid='AAAWWTAAKAAAADNAAA'
order by employee_id

No hay comentarios: