Posts

Showing posts with the label attitude

Featured Post

SQL Query: 3 Methods for Calculating Cumulative SUM

Image
SQL provides various constructs for calculating cumulative sums, offering flexibility and efficiency in data analysis. In this article, we explore three distinct SQL queries that facilitate the computation of cumulative sums. Each query leverages different SQL constructs to achieve the desired outcome, catering to diverse analytical needs and preferences. Using Window Functions (e.g., PostgreSQL, SQL Server, Oracle) SELECT id, value, SUM(value) OVER (ORDER BY id) AS cumulative_sum  FROM your_table; This query uses the SUM() window function with the OVER clause to calculate the cumulative sum of the value column ordered by the id column. Using Subqueries (e.g., MySQL, SQLite): SELECT t1.id, t1.value, SUM(t2.value) AS cumulative_sum FROM your_table t1 JOIN your_table t2 ON t1.id >= t2.id GROUP BY t1.id, t1.value ORDER BY t1.id; This query uses a self-join to calculate the cumulative sum. It joins the table with itself, matching rows where the id in the first table is greater than or

Career Vs Your Attitude Do These Now

Image
75% of the American workforce are actively looking for jobs at any given point in time, of which 69% of them are currently employed.  1. Networking  Tapping into your Network, Creating, and Maximizing your Personal Brand and Researching Companies in your Field of Interest will help you in finding jobs that suit your interest.  Trying to randomly find a job will get you nowhere. PREPARE, PLAN, and RESEARCH , and you will find a job that is meant for you.  If you have attended a get-together of friends or a social gathering off-late, chances are that you would have come across at least half a dozen people, talking about their jobs; how they are unhappy with it and looking for a change, or how difficult it seems to get one in the first place. Job Search. Searching for a job has become one of the most time-occupying tasks in recent times. Almost as difficult as getting one, a job search means researching, identifying, and applying for jobs and going through the functions of interviews, di