select rownum sql server code example Example: how to select a row in sql select * from [tableName] limit 1