You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ojb-user@db.apache.org by Ismail Siddiqui <is...@alloy.com> on 2003/03/12 20:26:35 UTC

Selecting Top 10 records??

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