Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about CollectivesStack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
Explore Stack InternalTry this
SELECT 100+ Sum(CASE WHEN b.name = 'a' THEN b.qty ELSE 0 END)OVER(ORDER BY itemorder DESC) as modifyed_sum, qty, name, itemorder FROM Yourtable ORDER BY itemorder ASC Another way
SELECT 100 + (SELECT Sum(CASE WHEN b.name = 'a' THEN b.qty ELSE 0 END) FROM yourtable b WHERE a.itemorder <= b.itemorder), qty, name, itemorder FROM yourtable a ORDER BY itemorder ASC Try this
SELECT 100+ Sum(CASE WHEN b.name = 'a' THEN b.qty ELSE 0 END)OVER(ORDER BY itemorder DESC) as modifyed_sum, qty, name, itemorder FROM Yourtable ORDER BY itemorder ASC Another way
SELECT 100 + (SELECT Sum(CASE WHEN b.name = 'a' THEN b.qty ELSE 0 END) FROM yourtable b WHERE a.itemorder <= b.itemorder), qty, name, itemorder FROM yourtable a ORDER BY itemorder ASC Try this
SELECT 100+ Sum(CASE WHEN name = 'a' THEN qty ELSE 0 END)OVER(ORDER BY itemorder DESC) as modifyed_sum, qty, name, itemorder FROM Yourtable ORDER BY itemorder ASC Another way
SELECT 100 + (SELECT Sum(CASE WHEN b.name = 'a' THEN b.qty ELSE 0 END) FROM yourtable b WHERE a.itemorder <= b.itemorder), qty, name, itemorder FROM yourtable a ORDER BY itemorder ASC Try this
SELECT 100+ Sum(If(name='a',CASE WHEN b.name = 'a' THEN b.qty, ELSE 0) END)OVER(ORDER BY itemorder DESC) as modifyed_sum, qty, name, itemorder FROM Yourtable ORDER BY itemorder DESCASC Another way
SELECT 100 + (SELECT Sum(CASE WHEN b.name = 'a' THEN b.qty ELSE 0 END) FROM yourtable b WHERE a.itemorder <= b.itemorder), qty, name, itemorder FROM yourtable a ORDER BY itemorder ASC Try this
SELECT 100+ Sum(If(name='a', qty, 0))OVER(ORDER BY itemorder DESC) as modifyed_sum, qty, name, itemorder FROM Yourtable ORDER BY itemorder DESC Try this
SELECT 100+ Sum(CASE WHEN b.name = 'a' THEN b.qty ELSE 0 END)OVER(ORDER BY itemorder DESC) as modifyed_sum, qty, name, itemorder FROM Yourtable ORDER BY itemorder ASC Another way
SELECT 100 + (SELECT Sum(CASE WHEN b.name = 'a' THEN b.qty ELSE 0 END) FROM yourtable b WHERE a.itemorder <= b.itemorder), qty, name, itemorder FROM yourtable a ORDER BY itemorder ASC Try this
SELECT 100+ Sum(IifIf(name='a', qty, 0))OVER(ORDER BY itemorder DESC) as modifyed_sum, qty, name, itemorder FROM Yourtable ORDER BY itemorder DESC Try this
SELECT 100+ Sum(Iif(name='a', qty, 0))OVER(ORDER BY itemorder DESC) as modifyed_sum, qty, name, itemorder FROM Yourtable ORDER BY itemorder DESC Try this
SELECT 100+ Sum(If(name='a', qty, 0))OVER(ORDER BY itemorder DESC) as modifyed_sum, qty, name, itemorder FROM Yourtable ORDER BY itemorder DESC