I have a SELECT Query and would like to pull the first "n" records. "n" is a variable that you would prompt the user to enter when the query is run. The query would retrieve the first "n" records. I cannot find a function that you can include in a query that keeps track of the current row number so I can accomplish this. Is there any way to create a query to do this?
SELECT * FROM table_blah LIMIT n
🙂
AaronZoller.com (Opening June 15th, 2002)
