Documentation enhancement: Add more usable examples in Limiting Query Results

[Hdvlp]

The documentation of Limiting Query Results can be enhanced by adding more usable examples.

I have added a repository to show that some example code builds and some fails. It is a time-saver to see more usable examples and use these examples before running into problems I encountered earlier in the error messages.

To handle At least 1 parameter(s) provided but only 0 parameter(s) present in query properly, a developer needs to know if the parameter inside the method name or if the parameter inside the brackets should be added. This is a potentially confusing area just by looking at this line of error message.

    User findByUsername(String username); // builds
    User findByLastname(String lastname); // builds
    User findFirstOrderByUsername(String username); // builds
    User findFirstOrderByLastname(String username); // builds

    User findFirstByOrderByUsernameAsc(); // builds
    User findFirstByOrderByLastnameAsc(); // builds
    User findFirstByOrderByFirstnameAsc(); // builds

    User findFirstByLastnameOrderByUsernameAsc(String lastname); // builds
    User findFirstByLastnameOrderByLastnameAsc(String lastname); // builds
    User findFirstByLastnameOrderByFirstnameAsc(String lastname); // builds
    User findFirstByLastnameOrderByIdAsc(String lastname); // builds

    User findFirstByUsernameOrderByUsernameAsc(String username); // builds
    User findFirstByUsernameOrderByUsername(String username); // builds
    User findFirstByUsernameOrderByUsernameDesc(String username); // builds

    User findFirstByOrderByUsername(String username); // fails to build

    User findFirstByOrderByUsernameAsc(String username); // fails to build

[bclozel]

I think you meant to create this issue against spring-data-jpa as this documentation is not maintained in this project. Thanks!