Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Row count

Status
Not open for further replies.
OraMs

OraMs

Programmer
Joined
Feb 12, 2000
Messages
40
Location
US

In ORACLE, you can use ROWNUM to select only a given number of rows. Is there something like this is Access? What is it?

Thanks in advance.
 
Sort by date Sort by votes
You can do something like this:

SELECT TOP 25
X, Y
FROM Z
WHERE A = "Something"
ORDER BY B Best Regards,
Mike
 
Upvote 0 Downvote

Thanks Mike. Now, what if I only want certain columns from the TOP 25 rows?

 
Upvote 0 Downvote

Mike, please disregard previous message. I got it. Thanks.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Question Question
Why does what appears to be a simple append query is pasting 5 duplicate rows?
Replies
9
Views
270
TheresAlwaysAWay
TheresAlwaysAWay
mhshane
  • Locked
  • Question Question
Query to find keywords in description field and give count
Replies
4
Views
605
Andrzejek
Andrzejek
supportsvc
  • Locked
  • Question Question
Distinct Count for Unique Number of Employees in Each Month
Replies
0
Views
292
supportsvc
supportsvc
OCM
  • Locked
  • Question Question
count by date
Replies
5
Views
458
OCM
OCM
Trebor423
  • Locked
  • Question Question
Parse delimited text from field into new row
Replies
15
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top