Oracle find first element in a group

Overview This is one of the common problems I have faced while writting Oracle queries. Data in relational tables is to be grouped together based on the criteria and top element of each group is to be printed out. In this article I have defined different ways of doing this by taking a simple example. Example Employee

Performance comparison between custom row mapper and Spring’s bean property row mapper

Custom Row Mapper Vs Spring’s Bean Property Row Mapper Nov 14′ 2015 For quering relational database tables from Java layer, developers have an option of either using JPA (Java persistence API) to directly map java objects with relational database tables or they can directly write SQL queries and execute them using JDBC connection (or Spring JDBC