Any SQL Database gurus

Posts 4 · Viewed 5200 · Go to Last Post

· Snapshot 0

Like · Likedby · 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?

SELECT T.year, SUM (S.sales)

FROM Sales S, Times T

WHERE S.timeid = T.timeid

GROUP BY T.year

open

· Snapshot 21

Like · Liked by · 0

I am not SQL Database guru but just check this works in your case.

SELECT T.year,
SUM (S.sales) OVER (PARTITION BY T.year)

FROM Sales S, Times T

WHERE S.timeid = T.timeid

Just give a try..

refugeeNP

· Snapshot 39

Like · Liked by · 0

Nope It didn't work. Also I want it to be using WINDOW clause in SQL 1999.
Any help will be appreciated.

Also any idea about first qustion??

ketama

· Snapshot 135

Like · Liked by · 0

Why don't you post your questions here. http://www.sqlteam.com/forums/
You might get better help there.

Please log in to reply to this post

You can also log in using your Facebook

View in Desktop

What people are reading

Visitor from US is reading Any SQL Database gurus

Visitor from CN is reading any one going to umass boston this fall

Visitor from US is reading Thank you for the sajha policy

Visitor is reading Petotioner birth certificate visa interview

Visitor from US is reading bring khukuri as presents from nepal

Visitor from US is reading Thank you for the sajha policy

Visitor from US is reading Don't fly Nepal Airlines

Visitor from US is reading Pls, help me--Important

Visitor is reading FREE INFORMATICA ONLINE TRAINING

You might like these other discussions...

apunge » Sexy In Sari

TPS EAD auto extended to June 2025 or just TPS?

· Posts 3 · Viewed 270

Tps8249

Texas GOP Amendment Would Stop Democrats Winning Any State Election

· Posts 1 · Viewed 77

haal haal pandit » logan

whats wrong living with your parents ?

· Posts 19 · Viewed 3144 · Likes 1

Sajha Classifieds

Classifieds Summary: Room/Apt in MA

· Posts 1 · Viewed 96

NepalNews Sajha

News Summary from Nepal for Tuesday, May 28, 2024

· Posts 1 · Viewed 82

Sajha Classifieds

Classifieds Summary: Jobs in MN,RI,VA, Room/Apt in MA,VA

· Posts 1 · Viewed 128

NepalNews Sajha

News Summary from Nepal for Monday, May 27, 2024

· Posts 1 · Viewed 137

Khaobaadi_Netaa » Tesla guy

अमेरिकाले सन्दीप लामिछानेलाई भिसा नदिएपछि आन्दोलनमा उत्रिय समर्थकहरु - LOL!!!

· Posts 4 · Viewed 1145

haal haal pandit

Tik tak banned in US?

· Posts 1 · Viewed 255

Sajha Classifieds

Classifieds Summary: Room/Apt in MA,NY,VA

· Posts 1 · Viewed 164