Posted by: refugeeNP April 26, 2011
Login in to Rate this Post:
0
?
What is the difference between WINDOW and GROUP BY clause?
How do you write the query below in SQL:1999 using WINDOW clause that is without using GROUP BY?
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 T
WHERE S.timeid = T.timeid
GROUP BY T.year