Improve Your Skills By Learning OVER with Aggregate Functions - Online Course

PHOTO

Wed Apr 26 2023 01:15:39 GMT+0000 (Coordinated Universal Time)

Saved by @vnmshenoy

SELECT p.id,

d.name,

p.item,

p.price,

min(p.price) over(),

p.price-min(p.price) over()

FROM purchase p

join department d on p.department_id=d.id

https://learnsql.com/track/advanced-sql/course/window-functions/over/Summary/exercise-2

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

SQL_windowFunction

@vnmshenoy

Learn How To Use SQL OVER Clause with WHERE in Query By Doing - Online Course Improve Your Skills By Learning OVER with Aggregate Functions - Online Course this one was tricky ...had to calculate ratio price::numeric / over the sum Learn How To Use RANK with ORDER BY in SQL - Practice SQL Online - what i liked is how you can order by 2 columns, each separately. Improve Your Skills By Learning About Ranking and ORDER BY - Online Course Learn SQL By Doing - Practice NTILE Function Queries Online Learn How To Select N-th Row in SQL - Practice SQL Online -CTE

Browse more snippets >>