Results 1 to 3 of 3

Thread: top 10 query

  1. #1
    Join Date
    Mar 2004
    Posts
    162

    Unanswered: top 10 query

    need help with a top10 query.

    I wont to see top 10 in a table... so far so good just use select top 10

    Then my problem begins, i wont a number of how many rows thats Not included in the top 10 statement, kinda inverted top 10. How can i achieve that? need help to get my thoughts going here

    Thx in advance

    //Mr

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    You could play with

    Code:
    SELECT Blah
    FROM BlahT
    WHERE NOT EXISTS(Your top 10 Query Corrolated with this one)
    or select top 90 percent and order everything that was ordered ASC in your top 10 query DESC.

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Mar 2004
    Posts
    162
    nice thoughts thx!

Posting Permissions

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