only one row sql code example

Example: select only one row sql

select * from your_table where rownum = 1;