TOP n [PERCENT]
Specifies that only the first n rows are to be output from the query result
set. n is an integer between 0 and 4294967295. If PERCENT is also specified,
only the first n percent of the rows are output from the result set. When
specified with PERCENT, n must be an integer between 0 and 100.
If the query includes an ORDER BY clause, the first n rows (or n percent of
rows) ordered by the ORDER BY clause are output. If the query has no ORDER
BY clause, the order of the rows is arbitrary.
chanmm
"Brad" <ba******@ukcdogs.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
I need to select the Top 50 records from a table of over 10,000 records and
all is working just fine, but I have a what if question.
What if the 50th record's value matches the 51st record (and possible the
52nd and so on)? Does the Select Command also include those records or
no? If not, how is the 50th record determined?
Thanks for the information.
Brad