problems limiting results for sql query

I am simply trying to pull a very large data set off of an sql server using SQL Navigator 4.5. There are over 2 million rows of data in this data set, and I would like to limit it to about 500,000. here is my code...
[code]select gs_zip from cleansed_address_archive[/code]

I tried putting "where row<10" and I get an error saying "9:24:53 ORA-00936: missing expression" some one please help... this seems like such a simple thing to solve but I have looked all over the internet for solutions and nothing has worked

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!