Order By

Hint

This article is generated by AI translation.

Build ordered queries with LambdaTemplate as follows.

Ordering basics

LambdaTemplate lambda = ...

List<User> result = null;
result = lambda.query(User.class)
               .ge(User::getId, 100)
               .orderBy(User::getName); // default (order by name)
             //.asc(User::getName);     // ascending  (order by name asc)
             //.desc(User::getName);    // descending (order by name desc)

// SQL: select * from users where id >= 100 order by name;

Multiple sort columns

LambdaTemplate lambda = ...

List<User> result = null;
result = lambda.query(User.class)
               .ge(User::getId, 100)
               .orderBy(User::getName)
               .orderBy(User::getAge);

// SQL: select * from users where id >= 100 order by name, age;

NULLS FIRST

LambdaTemplate lambda = ...

List<User> result = null;
result = lambda.query(User.class)
               .ge(User::getId, 100)
               .orderBy(User::getName, OrderType.DEFAULT, OrderNullsStrategy.FIRST);

// MySQL SQL: select * from users where id >= 100 order by name is null desc, name

NULLS LAST

LambdaTemplate lambda = ...

List<User> result = null;
result = lambda.query(User.class)
               .ge(User::getId, 100)
               .orderBy(User::getName, OrderType.DEFAULT, OrderNullsStrategy.LAST);

// MySQL SQL: select * from users where id >= 100 order by name is null asc, name

提示

• NULLS FIRST/LAST support depends on dialect; see database support for null ordering support.