Skip to content

DataForGeeks

for Data Enthusiasts

  • Home
  • SQL Problems
  • Contact Us

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

Connect with:

Categories

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

RSS Unknown Feed

Archives

  • 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