Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: [help] Top n records

    how to get exactly top n records?
    top didn't make choice between same values,
    that means if the nth value and (n+1)th value are the same
    i will get n+1 records.

    so top n means top n values, not top n records

    that is quite different from sql server

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    possible workaround?

    how do you want top n to decide in cases where n and n+1 are the same?

    ...make yourself a query field that evaluates that decision factor
    e.g. [Salary]+[UserID] or [Salary]+[ZIPcode] or [Salary]+Asc(left$([Name],1))
    and select the top n from there.

    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts