TOP Predicate in VB3 
Author Message
 TOP Predicate in VB3

I would be grateful if someone could show me how to create a SQL query
in VB3 that creates a result similar to the TOP n predicate available
in VB4.

I have a table with sales figures as one of the columns.  What I want
to do is return the top 5 sales figures in descending order using a
single SQL query.  For the life of me,  I cannot see a way to do this.

Any help would be gratefully appreciated.

Thanks in advance

Clive Carpenter

Clive Carpenter



Tue, 01 Jun 1999 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Parametrized Query with Optional TOP Predicate

2. TOP Predicate?

3. Question on Top X Access Predicate

4. Top predicate and quick access

5. VB3 (yes, VB3!) database question

6. VB3 (yes, VB3!) database question

7. VB3 to VB4 vs. VB3 to VB5

8. top 1 is fast, top 2-10 is slow, top 11-81 is semi fast, top 82-1000 is fast.

9. Urgent--Newbie, please Help!:-)--TOP 10 Plus Increments of the next TOP 10

10. Top Without Using Top

11. SQL - way to select the top 10 / top 20 from a database

12. Urgent--Newbie, please Help!:-)--TOP 10 Plus Increments of the next TOP 10


 
Powered by phpBB® Forum Software