Posts

Showing posts with the label Relative Vs Absolute Path

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

Relative Vs. Absolute Path in Linux: Top Differences

Image
 Here's the difference between the relative and absolute paths in Linux. Many a time, the programmer needs to trade in these paths. Here're simple ideas on how you can differentiate. Absolute Vs. Relative path These are the differences between Absolute and Relative path in Linux. Absolute Path $ cd /usr/lib $ cd /usr/lib pwd See this path (linux#1/usr/lib), when you give PWD, it gives a full path from the root level. This is called absolute or full path. Think of the absolute pathname as being the complete mailing address for a package that the postal service will deliver to your next-door neighbor. Relative Path $ cd usr $ /user cd lib $ /usr/lib pwd $ linux#1/usr/lib ==> Going step by step and achieving. $ linux#1/usr/lib cd ../../ ==> This is the method of going back step by step. $ linux#1 ==> This is root level directory You are currently in the lib directory. So relative path nothing but complete information of all the mother directories. Here, for lib, th