wood burning stoves 2.0
The moose likes JDBC and Relational Databases and the fly likes diplayed the row number by action wise Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "diplayed the row number by action wise" Watch "diplayed the row number by action wise" New topic

diplayed the row number by action wise

Geeta Ravikanti
Ranch Hand

Joined: Mar 26, 2008
Posts: 46
My Input is

Time Action

17:30 Sell
17:35 Sell
17:40 Buy
17:45 Buy
17:50 Sell
17:55 Buy
18:00 Sell
18:05 Sell
18:10 Sell

I want out put like following

Time Action RowNumber

17:30 Sell 1
17:35 Sell 2
17:40 Buy 1
17:45 Buy 2
17:50 Sell 1
17:55 Buy 1
18:00 Sell 1
18:05 Sell 2
18:10 Sell 3

my problem is i am getting the rownumbers 1,2,3,4,5,like so on
but how to get the row numbers like 'sell' and 'buy' wise(like aboe out put)
any one help in this query'
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32609

The easiest way is to do it in Java after the JDBC result is returned. If you need to do this in standalone SQL, the answer is database specific - if possible at all. What database are you using if you can't use JDBC.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link: http://aspose.com/file-tools
subject: diplayed the row number by action wise
It's not a secret anymore!