I need one logic to be diplayed in query level,ie
for one batch there may be n no of lots with different created date
for ex : records will look likeBatch No InspectionLotNo Created Date A 1 10.11.2012 A 2 11.11.2012 A 4 13.11.2012 A 3 12.11.2012 B 4 14.11.2012 B 3 13.11.2012 B 1 11.11.2012 B 2 10.11.2012
So in query level, I need last 10 records for particular batch based on descending datewise or Inspection Lot no wise.
we are instructed not to use conditions
Please help me to acheive this logic