Professional Web Applications Themes

Need help with select statement - Microsoft SQL / MS SQL Server

I have a table where each row has a column representing a bill denomination (e.g. 1, 2, 5, 10, 20, 50 or 100 dollar bill). I need a select statement that will give me a count of the number of rows for each denomination. Any help would be appreciated! Thanks! Don Miller...

  1. #1

    Default Need help with select statement

    I have a table where each row has a column representing a bill denomination
    (e.g. 1, 2, 5, 10, 20, 50 or 100 dollar bill). I need a select statement
    that will give me a count of the number of rows for each denomination. Any
    help would be appreciated!

    Thanks!
    Don Miller


    Don Guest

  2. #2

    Default Need help with select statement

    Arun replies:

    try this

    select denomination,count(denominiation) as Number of
    Bills from denomination table
    group by denomination
     
    bill denomination 
    select statement 
    denomination. Any 
    Arun[Symbiosis] Guest

  3. #3

    Default Re: Need help with select statement

    May I suggest adding a column for $500 bill. Although they are no longer
    produced, there are still some in circulation, assuming you're in the US.

    Ray at home

    --
    Will trade ASP help for SQL Server help


    "Don Miller" <com> wrote in message
    news:phx.gbl... 
    denomination 
    Any 


    Ray Guest

Similar Threads

  1. SP with Select statement
    By Gerald in forum ASP Database
    Replies: 3
    Last Post: November 27th, 03:38 PM
  2. SELECT statement
    By Simon in forum Microsoft SQL / MS SQL Server
    Replies: 23
    Last Post: August 18th, 01:12 PM
  3. possible to run a select with an if statement in it?
    By Jim in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 17th, 04:48 PM
  4. Need some help on a SELECT statement
    By Sydney in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: July 16th, 01:42 PM
  5. Select Statement Help Please
    By Bob in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 14th, 02:41 PM

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