Title: Using Analytics/SQL Server Functions
Last modified: September 14, 2020

---

# Using Analytics/SQL Server Functions

 *  Resolved [samonpress](https://wordpress.org/support/users/samonpress/)
 * (@samonpress)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/using-analytics-sql-server-functions/)
 * I might sound silly but I was wondering if we can use Server Functions in scripts?
   
   My objective is to create a running total column for which I’m trying to use
 * `SUM (col2) OVER (PARTITION BY col1 Order by Col1) As new_col;`
 * But its not seems to be working on upload.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [samonpress](https://wordpress.org/support/users/samonpress/)
 * (@samonpress)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/using-analytics-sql-server-functions/#post-13402443)
 * Resolved it by using inner join method which worked just fine. Used this link
   
   [https://www.youtube.com/watch?v=Xj4aEHIhk6A&t=264s](https://www.youtube.com/watch?v=Xj4aEHIhk6A&t=264s)
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/using-analytics-sql-server-functions/#post-13402711)
 * Great you solved it! 🙂 And thanks for sharing…

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Using Analytics/SQL Server Functions’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [5 years, 8 months ago](https://wordpress.org/support/topic/using-analytics-sql-server-functions/#post-13402711)
 * Status: resolved