my dog learned polymorphism*
The moose likes JDBC and the fly likes Please help with db query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Please help with db query" Watch "Please help with db query" New topic
Author

Please help with db query

Farakh khan
Ranch Hand

Joined: Mar 22, 2008
Posts: 726


I am able to display records on the basis of the above queries but trying to display records according to companies ranks of the posts in descending order

I am working with oracle XE and Java Servlet

Thanks & best regards
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29220
    
135

Farakh,
Take a look at the group by and order by clauses. They let you sort within an aggregate function.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Farakh khan
Ranch Hand

Joined: Mar 22, 2008
Posts: 726
Originally posted by Jeanne Boyarsky:
Farakh,
Take a look at the group by and order by clauses. They let you sort within an aggregate function.


Thanks a lot the problem solved
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Please help with db query
 
Similar Threads
Is it possible to get rowCount from ResultSet Object?
Why difference in result
problem in where clause while fetching records in jtable
Hibernate Query
Hibernate/Display tag Pagination (Poor/slow performance for the last set of pages)/ Oracle 10 G