Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with another query
Message
From
18/02/2003 11:18:27
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Help with another query
Miscellaneous
Thread ID:
00754488
Message ID:
00754488
Views:
49
hello, i have this query:

SELECT count(fechaingreso) as fecha
FROM registroempresas
group by fechaingreso

what i trying to do is find how many people appears in my table in a date range and from that extract the maximum of the values.
Right now it shows 42, 1, 3, 2, etc., but i need to choose only the 42 from there, how can i do this?
Next
Reply
Map
View

Click here to load this message in the networking platform