getting first row of table by criteria query

Question

How can I get the first row of a table by using criteria or HQL query?

Table creation script

   CREATE TABLE MonthlySubscriber(MSISDN bigint(20) 
   NOT NULL, MonthOfYear int(11) NOT NULL, 
   PRIMARY KEY (MSISDN));

Accept the answer and help people to trust on provided solution. — Jubin Patel, Feb 13 '15 at 04:08

Jubin Patel · Accepted Answer · 2013-07-24T05:21:15.077

31

Yes you can do that with setMaxResults & setFirstResult in criteria

Sample Code

Criteria queryCriteria = session.createCriteria(MonthlySubscriber.class);
queryCriteria.setFirstResult(0);
queryCriteria.setMaxResults(1);
monthlySubscriberList = queryCriteria .list();

edited Jul 24 '13 at 05:21

answered Jul 24 '13 at 05:13

Jubin Patel

1,959
19
38

2

Why the .setFirstResult(0) ? – Mark W Jun 30 '17 at 12:28
3

@MarkW setFirstResult is used for setting starting point from where take the result from the list. In this case, we need the result from first element of the list. – Nikhil Mishra Mar 15 '18 at 11:27

score 4 · Answer 2 · answered May 26 '17 at 02:34

4

you could do that like this:

Session session = getHibernateTemplate().getSessionFactory().getCurrentSession();
        String sql= "select b.wcd, a.optime from UseWaterRecord a, WellBasicInfo b where a.stcd=:a_stcd and b.stcd=:b_stcd ORDER BY a.optime desc";
        Query query = session.createQuery(sql);
        query.setString("a_stcd", "10100405");
        query.setString("b_stcd", "10100405");
        query.setFirstResult(0);
        query.setMaxResults(1);

        List wrwmList = query.list();

answered May 26 '17 at 02:34

Huang

51
4

this is not via criteria query – DragonKnight Sep 14 '21 at 19:56
BUT, it's HQL query – Huang Jun 08 '22 at 03:14

score 1 · Answer 3 · answered Sep 06 '20 at 14:03

1

 Criteria queryCriteria = currentSession.createCriteria(Project.class);
 queryCriteria.setFirstResult(0);
 queryCriteria.setMaxResults(1);
 entity = (Project) queryCriteria.uniqueResult(); // Casting to the Entity class

answered Sep 06 '20 at 14:03

Patrik Duch

11
1

uniqueResult(), nice. – jumping_monkey Mar 23 '22 at 08:36

score -3 · Answer 4 · answered Jul 24 '13 at 05:10

-3

public Criteria setFirstResult(int firstResult)

This method takes an integer that represents the first row in your result set, starting with row 0. REFER

answered Jul 24 '13 at 05:10

Ganesh Rengarajan

2,006
13
26

3

`setFirstResult` use to get start row but it gives all rows from below that. for that must have to use `setMaxResults`. – Jubin Patel Jul 24 '13 at 05:24
1

@JubinPatel isn't `setFirstResult` explicit in conjunction with `setMaxResults`? – Dragon Apr 21 '16 at 14:42

getting first row of table by criteria query

4 Answers4

Linked