Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Greatest N Per Group
I thought I had it, but when I use this, I get "currency not on a record" SELECT * FROM ( select a.tp_no, c.name, a.state, b.eff_date, a.er_rate as 'Actual', b.er_rate as 'Billed', (select MAX(e.eff_date) from "PR_TSUTA" as d left join CL_SUTA as e on(d.tp_no=e.loc_no) left join...- jeremib
- Post #2
- Forum: Pervasive: Pervasive.SQL
-
Greatest N Per Group
Using Pervasive SQL, I have a result set: Tp_No Name State Eff_Date Actual Billed 1006 ABC TN 2006-07-01 .1 .5 1006 ABC TN 2008-02-15 .27 .6 1006 ABC TN 2010-09-01 .37 .7...- jeremib
- Thread
- Replies: 1
- Forum: Pervasive: Pervasive.SQL
