AVG function

Question

Post reply

AVG function

krishnaroopa

SSChasing Mays

Points: 650
More actions
June 20, 2011 at 8:10 pm

#389792

Comments posted to this topic are about the item AVG function

Viewing 15 posts - 1 through 15 (of 24 total)

You must be logged in to reply to this topic. Login to reply

Gobikannan SSCrazy Points: 2735 More actions · Answer 1

Gobikannan

SSCrazy

Points: 2735

June 21, 2011 at 12:05 am

#1341617

Simple QotD today.

-----------------
Gobikannan

M&M SSC-Insane Points: 21700 More actions · Answer 2

M&M

SSC-Insane

Points: 21700

June 21, 2011 at 1:57 am

#1341668

Thank you Krishna

M&M

paul s-306273 SSChampion Points: 10730 More actions · Answer 3

paul s-306273

SSChampion

Points: 10730

June 21, 2011 at 3:54 am

#1341705

Nicee and easy if you read the question properly...

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 4

Easy question if you don't talk yourself into thinking it's a trick question.

http://brittcluff.blogspot.com/

Mike Palecek SSCommitted Points: 1560 More actions · Answer 5

I made the same mistake I make all the time and forget about the datatypes.

Good Question to make you think.

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 6

Daniel Bowlin

SSC-Dedicated

Points: 34566

June 21, 2011 at 7:13 am

#1341820

Good question. Thanks.

Mike Byrd Default port Points: 1458 More actions · Answer 7

Makes it even more interesting if you add following:

insert into @test-2 values ( NULL )

Answer is still 6.

Mike Byrd

ronmoses@gmail.com SSCarpal Tunnel Points: 4480 More actions · Answer 8

Mike Byrd (6/21/2011)
Makes it even more interesting if you add following:
insert into @test-2 values ( NULL )
Answer is still 6.

Because aggregate functions ignore NULLs, right?

Good question today, thanks. I had it nailed on theory and then almost got it wrong by screwing up the math. 24 divided by 4 is NOT 8, duh. Tuesday morning brain, I guess.

ron

-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown

SanDroid SSChampion Points: 10068 More actions · Answer 9

Britt Cluff (6/21/2011)
Easy question if you don't talk yourself into thinking it's a trick question.

I have noticed that thier have not been any question that could be confused as a "Trick Question" in a LONG time.

Thank you Steve!

SanDroid SSChampion Points: 10068 More actions · Answer 10

Nice easy clear to understand question. Thank you.

Ken SSCoach Points: 17191 More actions · Answer 11

Ken

SSCoach

Points: 17191

June 21, 2011 at 8:09 am

#1341854

Nice question. Simple and straight forward.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Yay - thanks for the ?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

LostAccount SSCarpal Tunnel Points: 4951 More actions · Answer 13

Thanks for the question. Reminds us to remember those datatypes.

Richard Warr SSCertifiable Points: 6968 More actions · Answer 14

Thanks. Good to see questions about things that come up all the time

AVG function

Cookies on SQLServerCentral