PDA

View Full Version : Query question - how to extract a number of hands



4entourage
09-02-2010, 07:37 PM
I have a query set to pull hands from the database based off certain parameters.

Like this :

WHERE handtimestamp > '6/10/2010 23:59:00'
AND handtimestamp < '6/31/2010 01:00:00'
AND gt.smallblind >= 200
AND gt.bigblind <=400

What would I add so that it also only pulls a specified count?
AKA I can extract "only 550 hands" if I wanted???

netsrak
09-04-2010, 09:05 AM
I think its something like select top(550) or something like that.
You should have a look into the postgresql sql documentation.