sql select only 1 record code example

Example: select only one row sql

select * from your_table where rownum = 1;