[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL: how to limit number of records in select?

Posted on 2000-04-25
3
Medium Priority
?
721 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 200 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month19 days, 1 hour left to enroll

834 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