Skip to content

DataForGeeks

for Data Enthusiasts

  • Home
  • SQL Problems
  • Newsletter

Month: July 2019

Columns with Sum of positive and negative values.

August 11, 2019July 15, 2019 by Nikhil Aggarwal

A table with single column is provided with integer values. Task is to create two separate columns with sum of positive and negative values respectively.   Input Table: integer_values id 5 15 25 0 -20 -30 Output Table sum_positive sum_negative 45 -50   Explanation : Sum of positive numbers ( i.e. 5,15,25) is 45 Sum … Read more

Categories SQL Tags Easy Leave a comment

Follow Me on LinkedIn

Connect Now

Connect with:

Subscribe to our newsletter!

RSS DataForGeeks

  • What It Really Takes to Run Snowflake’s Snowpipe in Production at Scale – A Comprehensive Guide May 28, 2025
  • Apache Iceberg: The Data Lake Breakthrough That’s Reshaping the Big Data Landscape May 21, 2025
  • The Medallion Masterstroke: How Databricks Rewired the Data World One Bronze Layer at a Time January 20, 2025
  • Mastering Python Setup on macOS: Bye Conda, Hello pyenv + Fancy iTerm2 Terminal October 9, 2024
  • Python Data Structures Simplified: List, Tuple, Dict, Set, Frozenset & More May 2, 2024

Categories

  • Big Data (9)
    • HDFS (1)
    • Impala (5)
    • Sqoop (3)
  • General (14)
  • Redshift (1)
  • Snowflake (2)
  • SQL (15)

Archives

  • May 2025 (2)
  • January 2025 (1)
  • October 2024 (1)
  • May 2024 (1)
  • September 2023 (1)
  • May 2022 (2)
  • March 2022 (1)
  • February 2022 (1)
  • May 2020 (1)
  • November 2019 (1)
  • July 2019 (1)
  • May 2019 (1)
  • March 2019 (1)
  • December 2018 (2)
  • August 2018 (2)
  • July 2018 (2)
  • June 2018 (1)
  • May 2018 (2)
  • April 2018 (1)
  • March 2018 (2)
  • July 2016 (4)
  • June 2016 (3)
  • June 2015 (2)
  • October 2011 (3)
  • November 2009 (2)
© 2022 DataForGeeks