Professional Web Applications Themes

Count(Alias.*) - Is it possible? - Microsoft SQL / MS SQL Server

COUNT(tbl.*) is not a valid T-SQL aggregate; COUNT(*) is. Also note that, COUNT(*) is different from COUNT(expression). In your case, you'll have to use COUNT(*) instead of COUNT(tbl.*) to avoid the error. -- - Anith ( Please reply to newsgroups only )...

  1. #1

    Default Re: Count(Alias.*) - Is it possible?

    COUNT(tbl.*) is not a valid T-SQL aggregate; COUNT(*) is. Also note that,
    COUNT(*) is different from COUNT(expression).

    In your case, you'll have to use COUNT(*) instead of COUNT(tbl.*) to avoid
    the error.

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Guest

  2. #2

    Default Re: Count(Alias.*) - Is it possible?

    It has nothing to do with the alias but everything to do with the COUNT()
    function. You can get more detail here.

    http://msdn.microsoft.com/library/en-us/tsqlref/ts_ca-co_5790.asp?frame=true


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


    "London Developer" <com> wrote in message
    news:phx.gbl... 
    count? 


    oj Guest

  3. #3

    Default Re: Count(Alias.*) - Is it possible?

    Doesn't your second query give the result you want? Explain what you are
    trying to count.


    You can't use Alias.* inside COUNT(). COUNT(*) causes a lot of confusion.
    The asterisk in COUNT(*) has nothing to do with a column name list - it's
    just a peculiar form of syntax which means "count all rows". Think of
    COUNT(*) and COUNT(column_name) as entirely different aggregate functions.

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


    David Guest

  4. #4

    Default Re: Count(Alias.*) - Is it possible?

    SELECT
    (SELECT COUNT(*)
    FROM
    (SELECT DISTINCT Col1, Col2
    FROM Table1) AS A),
    (SELECT COUNT(*)
    FROM
    (SELECT DISTINCT Col1, Col2
    FROM Table2) AS B)

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


    David Guest

  5. #5

    Default Re: Count(Alias.*) - Is it possible?

    Thanks David, that's really helpful.
    I guess I should have explained my exact requirements before posting.....!

    "David Portas" <org> wrote in message
    news:phx.gbl... 


    London Guest

Similar Threads

  1. Count(*) different than record count
    By Bosconian in forum MySQL
    Replies: 6
    Last Post: October 5th, 11:21 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