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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

'croping' query set

Status
Not open for further replies.
botsGuy

botsGuy

Programmer
Nov 12, 2002
5
AU
Does anyone know how to, for example,
select the top 10 records in an ordered query set in mySQL. Any help would be much appreciated.

Cheers,

James
 
Sort by date Sort by votes
SELECT ... FROM table ORDER BY column LIMIT 10 ;-)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
504
EdLentz
EdLentz
trandrus
  • Locked
  • Question
incrementing a column without having to query the db first
Replies
4
Views
170
Chris Miller
Chris Miller
martinkaeser
  • Locked
  • Question
MySQL Query for incrementing field from duplicates in database
Replies
4
Views
170
martinkaeser
martinkaeser
madcelt
  • Locked
  • Question
Select query not showing error but not showing result either
Replies
2
Views
134
madcelt
madcelt
Filip Boga
  • Locked
  • Question
MYSQL Query
Replies
1
Views
133
feherke
feherke

Part and Inventory Search

Sponsor

Back
Top