Posts

Showing posts with the label Mobile Technology

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

Social Media and Mobile Technology for Health care

Image
(People also click these jobs to  know skill set  and to apply  even from your phone!!) The ubiquity of mobile phone accessibility around the world is increasing. Worldwide the number of mobile phones in use grew from fewer than 1 billion in 2000 to around 6 billion in 2012. Recent estimates conclude that over 75% of the world' s population have access to a mobile phone (World Bank, 2012). Globally, there has been a rapid rise in the use of smart phones by consumers with over 1 billion Smart Phones subscribers (Approximately 30% of smartphone users are likely to use wellness apps by 2015, (Bjornland, Goh, Haanæs, Kainu, & Kennedy, 2012) with more than 30 billion mobile applications being downloaded in 2011 (World Bank, 2012). Along with this increase in penetration, there has been a significant increase in the development and deployment of mobile software applications across multiple computing platforms (e.g. smart phones, tablets and laptops). The most pop