Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Recording sql query

 
kirankumar dondapati
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 95
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why ar eu posting this in Struts forum?
Please use JDBC forums
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic