Select statement

[smcdmc]

Try something like this:

Select contract_number, location
from TABLE_NAME where rownum < 2;

This will return only one row.