Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbionic
Starting Member
1 Post |
 Posted - 2014-11-05 : 14:53:05
|
The database consists of the following tables:create table dbo.customer ( customer_id int identity primary key clustered, customer_name nvarchar(256) not null)create table dbo.purchase_order ( purchase_order_id int identity primary key clustered customer_id int not null, amount money not null, order_date date not null)Implement a query for the report that will provide the following information: for each customer output at most 5 different dates which contain abnormally high or low amounts (bigger or less than 3 times SDTDEV from AVG), for each of these dates output minimum and maximum amounts as well.Possible result: http://triontp.pop3.ru/333.gif |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-11-05 : 16:40:50
|
What code and results do you have right now?
No amount of belief makes something a fact. -James Randi |
 |
|
|
|
|
|
Finding 5 most recent records for each customer wi