Link Details

In this blog post, lets try to use JPA to fetch summary of records from database. We often have a requirement where we need to provide a summary of the data present. For example, I want to get summary of results of a recently conducted exam. So from a database table, I need to get Summary containing count of students who have passed, got promoted or failed the exam. So our summary record shall have Passed, Promoted and Failed as columns. An SQL query to do similar task could be

Posted by agirish  |   Nov 13 2012 / 08:38

Add your comment

Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Recommended Links

Written by: Ryan Knight
Featured Refcardz: Top Refcardz:
  1. Apache Hadoop
  2. Play
  3. Akka
  4. Debugging JavaScript
  5. Design Patterns
  1. Apache Hadoop
  2. REST
  3. Java
  4. Git
  5. Java Performance
Connect with DZone