Professional Web Applications Themes

simple query help - Microsoft SQL / MS SQL Server

I am very new to writing even the most basic queries, and hope one of you would be willing to help me out. I am trying to query a database for duplicate item numbers. select * from IV00101 where itemnmbr = itemnmbr above is what I thought the query should look like, but I was wrong it returned everything with an item number. Can someone please put me back on track? Thanks, Dana Wanner...

  1. #1

    Default simple query help

    I am very new to writing even the most basic queries, and hope one of you
    would be willing to help me out.

    I am trying to query a database for duplicate item numbers.


    select * from IV00101 where itemnmbr = itemnmbr

    above is what I thought the query should look like, but I was wrong it
    returned everything with an item number. Can someone please put me back on
    track?

    Thanks,
    Dana Wanner


    Dana Guest

  2. #2

    Default Re: simple query help

    Try :

    SELECT itemnmbr, COUNT(itemnmbr)
    FROM IV00101
    GROUP BY itemnmbr
    HAVING COUNT(itemnmbr) > 1 ;

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Guest

  3. #3

    Default Re: simple query help

    This will show you how many times itemnmbr is duplicated within the table.

    SELECT itemnmbr, count(*) FROM IV00101 GROUP BY itemnmbr HAVING COUNT(*) > 1

    --
    Keith, SQL Server MVP

    "Dana Wanner" <com> wrote in message news:phx.gbl... 
    Keith Guest

  4. #4

    Default Re: simple query help

    thanks guys! that did it.
    "Dana Wanner" <com> wrote in message
    news:phx.gbl... 
    on 


    Dana Guest

Similar Threads

  1. simple (?) query--help
    By Bosconian in forum MySQL
    Replies: 2
    Last Post: December 20th, 12:43 AM
  2. (simple?) query dilemma--help please
    By Bosconian in forum MySQL
    Replies: 2
    Last Post: November 19th, 02:00 AM
  3. Simple Query for Search
    By amystephenson in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: May 12th, 01:13 PM
  4. [PHP] Simple forms query
    By Matt Matijevich in forum PHP Development
    Replies: 2
    Last Post: July 9th, 04:50 PM
  5. simple query....
    By rodger in forum Microsoft SQL / MS SQL Server
    Replies: 6
    Last Post: July 2nd, 01:17 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