File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Struts and the fly likes Recording sql query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Recording sql query" Watch "Recording sql query" New topic

Recording sql query

kirankumar dondapati

Joined: May 25, 2007
Posts: 4
i have id-primary key,jobNo-it can have repeated values,owner of job and start date fields in a table. i want to write query which will extract current owner of job ,jobno, with the date when the job was started for example
ID jobNo ownerofjob startdate
1 99 kiran 8-02-07
2 99 dondapati 09-03-07
3 99 sunil 12-03-07
4 1000 ask 14-03-07
i want result as 99,sunil and date 8-02-07(when the job started)
please help regarding this .
Ajit Kanada
Ranch Hand

Joined: Jan 23, 2001
Posts: 95
Why ar eu posting this in Struts forum?
Please use JDBC forums

I agree. Here's the link:
subject: Recording sql query
It's not a secret anymore!