Recent content by jsteeleiii@cox.net

  1. J

    MS Access SQL - Select to Limit Rows

    I am querying ORACLE tables through a fairly slow network connection. While building the tables and testing for data, I do not need all of the records (300,000+). I just need a snapshot of the data so that I can test my field mapping. I have tried the SELECT TOP ## command, but the...
  2. J

    Select top 5 from query

    The top 5 would need to go after the SELECT DISTINCTROW: SELECT DISTINCTROW TOP 5
See more
Back
Top Bottom