how to select only one item in sql code example

Example: select only one row sql

select * from your_table where rownum = 1;