vom: 01.03.2016 von: Philadelphia Visual FoxPro User Group
Philadelphia VFP User Group--Tues., March 8--Tamar E. Granor  
ThePhiladelphia VFP User Group meets Tuesday, March 8 at 7:00 PM in room 125, Devry University, 1140 Virginia Drive, Fort Washington, PA. Feel free to come as early as 6:30 and bring some dinner. Our speaker this month will be member Tamar E. Granor who?ll present ?Going OVER and Above with SQL.? Abstract: The SQL 2003 standard introduced the OVER keyword that lets you apply a function to a set of records. Introduced in SQL Server 2005, this capability was extended in SQL Server 2012. The functions allow you to rank records, aggregate them in a variety of ways, put data from multiple records into a single result record, and compute and use percentiles. The set of problems they solve range from removing exact duplicates to computing running totals and moving averages to comparing data from different periods to removing outliers. In this session, we'll look at the OVER operator and the many functions you can use with it. We'll look at a variety of problems that can be solved using OVER.

Link zum Thema http://vfpphilly.blogspot.com