Professional Web Applications Themes

count of distinct rows - Microsoft SQL / MS SQL Server

Hi, I want to find count of distinct rows from a table using single sql statement. something like this : select count(distinct *) from trx_pend Is there any way to do this. Thanks in advance....

  1. #1

    Default count of distinct rows

    Hi,
    I want to find count of distinct rows from a table using
    single sql statement.

    something like this :
    select count(distinct *) from trx_pend

    Is there any way to do this.
    Thanks in advance.



    priya Guest

  2. #2

    Default Re: count of distinct rows

    Hi Priya,

    Is there a Primary key column in the table?? If so then you might want to
    use Count(distinct <PKeyColumn>)

    If not then can you tell us why you would want this to be in one single
    select statement??

    Thanks,
    Ram Thiru



    --
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Use of included script samples are subject to the terms specified at
    http://www.microsoft.com/info/cpyright.htm

    "priya" <com> wrote in message
    news:059901c34d84$355dd6f0$gbl... 


    Ram Guest

  3. #3

    Default Re: count of distinct rows

    SELECT COUNT(*)
    FROM
    (SELECT DISTINCT *
    FROM trx_pend) AS X

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "priya" <com> wrote in message
    news:059901c34d84$355dd6f0$gbl... 


    David Guest

  4. #4

    Default count of distinct rows

    hi priya

    since you are looking for DISTINCT * where you are
    looking for distinct records and not just based on
    particular field.I Suggest you use group by in this case.


    SELECT Count(*) from Table Group By Field1,Field2

    HTH
    Vish

     
    vishnat Guest

Similar Threads

  1. rows count
    By Aaron Bertrand - MVP in forum ASP Database
    Replies: 2
    Last Post: April 8th, 11:22 AM
  2. distinct, count
    By Frances in forum MySQL
    Replies: 3
    Last Post: December 2nd, 07:42 PM
  3. Needed, COUNT(DISTINCT *) workaround for ACCESS
    By rickaclark54 in forum Macromedia ColdFusion
    Replies: 4
    Last Post: March 14th, 08:07 PM
  4. [PHP] count rows
    By John Taylor-Johnston in forum PHP Development
    Replies: 1
    Last Post: August 22nd, 08:00 AM
  5. Count two distinct items in a table.
    By David in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 16th, 04:57 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