MS SQL Aggregate Function

Question

MS SQL Aggregate Function

Viewing 7 posts - 1 through 8 (of 8 total)

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

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 1

Please post what you tried so we can see things like what you tried to GROUP BY. Thanks.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

kmohan39 Valued Member Points: 70 More actions · Answer 2

Hello there,

This is the Task:

Select the title_id, type, and price from the titles table along with an average price for all tables

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 3

kmohan39 (11/19/2008)
Hello there,
This is the Task:
Select the title_id, type, and price from the titles table along with an average price for all tables

Not what I asked for... I want to see the code that you've actually tried... not pseudo code.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

kmohan39 Valued Member Points: 70 More actions · Answer 4

select title_id, type, price, avg(price)

from titles

group by title_id, type, price

order by type

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 5

SELECT t.Title_ID, t.Type, t.Price, d.AvgPrice

FROM dbo.Titles t

INNER JOIN

(--==== Derived table "d" finds average Price for each Type

SELECT Type, AVG(Price) AS AvgPrice

FROM dbo.Titles

GROUP BY Type) d

ON t.Type = d.Type

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

kmohan39 Valued Member Points: 70 More actions · Answer 6

kmohan39

Valued Member

Points: 70

November 19, 2008 at 9:43 pm

#900865

Thank you Jeff Moden

newbie

😎

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 7

You bet. Thank you for the feedback.

Now you know why I asked to see your query. For more information on how to get better answers quicker on future posts, take a look at the link in my signature line.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)