sql return only one row code example

Example: select only one row sql

select * from your_table where rownum = 1;