Hi,

Thanks for the reply.

However, the select query gives the results as min of dateime1 and max of datetime1. The o/p which I want is like

cardno, date, intime, outtime

1111, 04-02-2013, 08:45, 16:10

2222, 04-02-2013, 11:45, 16:10

i.e. datewise.

Please help.