Professional Web Applications Themes

Question about Top n - Microsoft SQL / MS SQL Server

I am trying to generate a query that will give me a top 5 report of calls anwered by our drivers. It almost works, it does give me the top 5 the problem is that there really should be 7. The bottom 4 records all have 35 as their number but only 2 show up. Is there a way to get all there records that have the same amount of Calls as the bottom 2 to show up? SELECT TOP 5 EmpID, Calls FROM dbo.Calls ORDER BY Calls DESC, EmpID EmpID Calls 0056 41 0089 40 0118 37 0095 35 ...

  1. #1

    Default Question about Top n

    I am trying to generate a query that will give me a top 5 report of calls
    anwered by our drivers. It almost works, it does give me the top 5 the
    problem is that there really should be 7. The bottom 4 records all have 35
    as their number but only 2 show up. Is there a way to get all there records
    that have the same amount of Calls as the bottom 2 to show up?

    SELECT TOP 5 EmpID, Calls
    FROM dbo.Calls
    ORDER BY Calls DESC, EmpID

    EmpID Calls
    0056 41
    0089 40
    0118 37
    0095 35
    0099 35
    --------------

    I need the records below to also show up
    0102 35
    0108 35

    Thanks


    M Guest

  2. #2

    Default Re: Question about Top n

    Use TOP n WITH TIES.

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "M Smith" <org> wrote in message
    news:#phx.gbl... 
    35 
    records 


    Jacco Guest

  3. #3

    Default Re: Question about Top n

    SELECT TOP 5 WITH TIES EmpID, Calls
    FROM dbo.Calls
    ORDER BY Calls DESC, EmpID

    --
    -oj
    RAC v2.2 & QALite!
    http://www.rac4sql.net


    "M Smith" <org> wrote in message
    news:#phx.gbl... 
    35 
    records 


    oj Guest

Similar Threads

  1. Newbie Question: Biz Card Template Question
    By Thomas_Porter@adobeforums.com in forum Adobe Indesign Windows
    Replies: 4
    Last Post: May 30th, 08:08 AM
  2. Replies: 9
    Last Post: April 27th, 04:44 AM
  3. Pen Tool Use Question. (Embarrassingly Newbie Question)
    By Bozo Schmozo in forum Macromedia Flash
    Replies: 0
    Last Post: November 12th, 10:00 PM
  4. regexp question + html::pr question on the side
    By boris in forum PERL Miscellaneous
    Replies: 4
    Last Post: September 27th, 02:24 AM
  5. newB question: related tables question
    By Blue man in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: June 30th, 04:13 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139