select only one row where code example

Example: select only one row sql

select * from your_table where rownum = 1;