![]() |
TopQuery.doc (beginner) |
Post Reply ![]() |
Author | |
Roger Carlson ![]() Microsoft MVP ![]() Joined: 20 Feb 2008 Status: Offline Points: 261 |
![]() ![]() ![]() ![]() ![]() Posted: 16 Jul 2008 at 11:02pm |
Please consider donating $1 per sample downloaded, find out why here.
TopQuery.doc Illustrates issues involving the TOP predicate
SQL, the query language of Microsoft Access, has many powerful, yet little known features. One of these is the Top Query. A Top query allows you to limit the results of a query to a certain number (or percentage) of records. The term "top" is deceiving, because it implies "largest" values. However, this is not strictly the case. You can choose the top largest values or the top smallest values. As we will see later, you can even choose random records Document with Sample Databases |
|
|
|
![]() |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |