Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Indrawati
  • Content: Threads
  • Order by date
  1. Indrawati

    SQL Intersect?

    Hi Could someone tell me how I can select records e.g. 501-1000 in a table using SQL? I've tried using something like (the table Data has 3000 records): (SELECT TOP 1000 * FROM Data ORDER BY ID ASC) INTERSECT (SELECT TOP 2500 * FROM Data ORDER BY ID DESC) but apparently MS Access 2000 does...
  2. Indrawati

    SQL Select newbie question

    Hi I currently have a database which contains 3000 records. What I want to do is, I want to extract only 2500 records out of this 3000. I know I can select the top 2500 with SQL SELECT TOP statement, but is there a way for me to select, let's say records 1-500 and 1001-3000? Thanks!

Part and Inventory Search

Back
Top