Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Query
Message
From
14/08/2003 04:58:34
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00819247
Message ID:
00820043
Views:
18
Hi Ravi,

you can do this on MSQL, but not on VFP.
SELECT * FROM EmpSalary SOURCE;
 WHERE Salary IN (SELECT TOP 2 Salary FROM EmpSalary WHERE Deptt=SOURCE.Deptt ORDER BY 1 DESC)
Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform