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 SkipVought 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
Feb 12, 2000
40
0
0
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

mhshane
  • Locked
  • Question
Query to find keywords in description field and give count
Replies
4
Views
68
Andrzejek
Andrzejek
supportsvc
  • Locked
  • Question
Distinct Count for Unique Number of Employees in Each Month
Replies
0
Views
36
supportsvc
supportsvc
OCM
  • Locked
  • Question
count by date 1
Replies
5
Views
56
OCM
OCM
Trebor423
  • Locked
  • Question
Parse delimited text from field into new row
Replies
15
Views
145
Andrzejek
Andrzejek
0sprey
  • Locked
  • Question
Query by Month-Year and with a Record Count Field
Replies
1
Views
48
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top