Oracle Select Statement

Limit the output of select to the first 20 rows

select * from v$sesstat where ROWNUM between 1 and 20;

Select unique values.

 select DISTINCT SID from v$sesstat;