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 |
|
rolltoheaven
Starting Member
1 Post |
 Posted - 2011-04-27 : 01:56:37
|
| First whats the difference between two WINDOW and GROUP BY clause in SQL:1999.Second,How do you write the query below in SQL:1999 using WINDOW clause that is without using GROUP BY?SELECT T.year, SUM (S.sales)FROM Sales S, Times TWHERE S.timeid = T.timeidGROUP BY T.year |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-04-27 : 02:07:06
|
homework ? assignment ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
|
|
|
|
|
Question about WINDOW and GROUP BY Clause?