Solved

SQL: how to limit number of records in select?

Posted on 2000-04-25
3
713 Views
Last Modified: 2010-04-04
I'm using paradox tables.  I wish to limit the number of returned records from a SQL select satement (the first 40 records) with varying ORDER BY parameters.
Can I do this?
0
Comment
Question by:rwv
3 Comments
 

Accepted Solution

by:
Shakari earned 100 total points
ID: 2747979
you can add to select a count command

select * from table1 order by field where count<41
0
 

Expert Comment

by:lgmm
ID: 2747995
the only way to do this is that you add a field in your end query  and use a statement in where

where field <= 40

im not sure if in delphi exists the recno() function , is similar the use

0
 
LVL 3

Expert Comment

by:shenqw
ID: 2750177
It's difficult to do that use only SQL in Paradox,Easy in Oracle & Ms SQL.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to use Hashing sha1 in Delphi 2010 4 272
Delphi TcxGrid group footer summary 3 268
delphi prevent click fast 2 218
Drag & Drop... Data from one grid to another 2 15
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question