This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
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 .