Any SQL Database gurus

Posts 4 · Viewed 12224 · 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 is reading How Long Does it Take to Climb Mount Everest?

Visitor from US is reading Any SQL Database gurus

Visitor is reading Anyone looking for Job in IT System Operation and Admin fiel

Visitor is reading Blame the Bauns ...

Visitor is reading Roomate/Room available Sunnyvale, CA

Visitor is reading What stocks to buy -- Any recommendation

Visitor is reading any agreement needed for room rent

Visitor is reading Bringing Gold to Nepal

Visitor is reading THere are self taught Nepalese kids too but do anyone of us

You might like these other discussions...

Sexy In Sari » Oops i did it again

Supreme Court Decision Crushes TPS Dreams

· Posts 7 · Viewed 2125 · Likes 1

jimmyaja

Good Morning Nepal! June 22nd 2026

· Posts 1 · Viewed 169

jimmyaja » Logan

The RSP Convention

· Posts 2 · Viewed 485

Sajha Classifieds

Classifieds Summary: Room/Apt in MA

· Posts 1 · Viewed 170

NepalNews Sajha

News Summary from Nepal for Monday, June 22, 2026

· Posts 1 · Viewed 179

jimmyaja

What They Said!

· Posts 1 · Viewed 235

ojhasamajdhangadhi

डम्बर ठगुन्ना ज्यूले प्रदेशबाट घरदेश सम्म सन्देश प्रवाह गर्नुभएको छ। उहाँले भन्नुभएको छ आफू प्रदेशमा बसेर भएपनि घर देशको धेरै याद आउँछ। र गाउँघरमा आजकाल संस्कृति हराउन लागेको छ। हामीले नबचाए कसले बचाउने???

· Posts 1 · Viewed 185

jimmyaja

Good Morning Nepal! June 21st, 2026

· Posts 1 · Viewed 289

jimmyaja

The 10+2 Natak

· Posts 1 · Viewed 343

pywokecharm

To open the strait of hormuz, it needs to be closed first - Orange Jesus edition

· Posts 1 · Viewed 266