Selecting Top 10 records??

[Ismail Siddiqui]

Hi all
I am using QueryByCriteria  as following

PersistenceBroker broker =
PersistenceBrokerFactory.defaultPersistenceBroker();
                broker.beginTransaction();
                Criteria c = new Criteria();
                c.addEqualToColumn("program_instance_id", program_instance_id+"");
                c.addOrderByDescending("score");
                QueryByCriteria query = new QueryByCriteria(Game.class, c);
                        Collection game =
broker.getCollectionByQuery(query);

I am running microsoft sql server and want to select only top 5 records
..like select top 5  * where ....  How can I put this condition in Criteria


Thanks

ismail


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]