Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select
Message
From
15/04/2016 15:50:18
Kevin Goff
Pennsylvania, United States
 
 
To
15/04/2016 13:59:54
Tamar Granor
Tomorrow's Solutions, Llc
Elkins Park, Pennsylvania, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: SQL Select
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01634840
Message ID:
01634864
Views:
52
>This is tricky in VFP (easier in SQL Server), but there are a couple of options. This article shows two ways to do it in VFP and then switches to SQL Server: http://www.tomorrowssolutionsllc.com/Articles/Getting%20the%20Top%20N%20for%20each%20Group.pdf
>
>Tamar


Minor point in the PDF - CTEs are Common Table Expressions, not Computed Table Expressions.
"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform