select rownum in sql sql server code example

Example: how to select a row in sql

select * from [tableName] limit 1