Any SQL Database gurus

Posts 4 · Viewed 9019 · 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 is reading there you go GATES!

Visitor from US is reading sardarji

Visitor is reading Help Needed: How to file i130 and 1485 concurrently for pare

Visitor is reading यस्तो पनि आमा ...........

Visitor is reading Help to find free text messaging site

Visitor is reading student with J1 visa

Visitor from US is reading Video: New Nepal ????

Visitor from US is reading A suicidal approach to national security

You might like these other discussions...

Oops i did it again » Oops i did it again

किन नेपाली बिद्यार्थीहरू आजकल आत्तिन थालेका छन?

· Posts 3 · Viewed 624

LOGAN » LOGAN

अब चै यिनको दिमाग पुरै गए जस्तो छ ?

· Posts 5 · Viewed 1691

ojhasamajdhangadhi » LOGAN

गोपाल हमाल र रास्वपाबीच भेट्को अर्थ के ? प्रवेशको संकेत कि सामान्य राजनीतिक संवाद ?

· Posts 2 · Viewed 396

Sajha Classifieds

Classifieds Summary: Room/Apt in MD,VA

· Posts 1 · Viewed 199

NepalNews Sajha

News Summary from Nepal for Wednesday, December 24, 2025

· Posts 1 · Viewed 212

Sexy In Sari » Sexy In Sari

Nepalese in the USA

· Posts 21 · Viewed 4345

Khaobaadi_Netaa

Why do home owners & builders don't care about heat & cold insulation in Nepal ?

· Posts 1 · Viewed 325

Babu Neupane » sapna1

room for rent in Jackson Heights

· Posts 2 · Viewed 2464

SHINEON » sapna1

looking for a female roommate

· Posts 3 · Viewed 14523

Sajha Classifieds

Classifieds Summary: Room/Apt in MA,VA

· Posts 1 · Viewed 269