write a query to retrieve latest records from the target table means if we have used scd2 version type of dimension, than retrieve the record with highest version no.for eg
verno id loc 1 100 bang 2 100 kol 1 101 bang 2 101 chen
we have to retrieve 100/kol and 101/chen. how it is possible through query.
RE: write a query to retrieve latest records from the ...
hi solution is here. hi ranganath u r answer is wrong it will give latest of all employee records.but the question is latest record of each employee.for this this is d answerselect x.* from tablewname x where rowid in (select max(rowid) from tablename group by empno );i hope this will be the exact answer.
