how can select

[idsanjeev]

i have need help in sql Select stetements.
i am very confuse for a quary
my need to select first entry and last out datewise of all memeber that is stored in table and member is enter and out more than one time a day but i have to display perday first entery and last out between selected months

[amitpatel66]

i have need help in sql Select stetements.
i am very confuse for a quary
my need to select first entry and last out datewise of all memeber that is stored in table and member is enter and out more than one time a day but i have to display perday first entery and last out between selected months

I assume you are looking for something like this:

 
SELECT x.member_name FROM table x WHERE (x.date_logged_in,x.logged_out) = (SELECT MIN(logging_time),MAX(logging_time) FROM table WHERE member_name = x.member_name)
 
 

The login and logout details are refering to same column in the table?

[debasisdas]

Are you working on something like an attendance register ?

[idsanjeev]

Hi debasisdas
Yes you are right i am woking on attance system.
i am using two table thats is let me try to define
my table name is acs_data and its field is empno,opdate,optime,ioflg,cardno,seqno
empno is no of member, opdate is date optime is time ioflg is i for in and o for out card no is both side of door that is encoded i or o and othe tbale is emptable where empno, empname,
designame and i have to display all employee records/perday with maximum out and minimum in time
thanks

[idsanjeev]

Thanks
by using this i am getting the result thats are required

Set RS3=CON.Execute(" SELECT a.EMPNO,a.seqno,TO_CHAR(a.OPDATE,'DD-Mon-YYYY') OPDATE , b.dscr,a.optime,a.ioflg,a.PNCH_FLG FROM ACS_DATA a, M_CARD b WHERE a.cardno = b.readerno AND EMPNO IN (SELECT EMPNO FROM M_FIX_EMPLOYEE@alf2 WHERE opdate>= '15-jan-2008' AND opdate <='25-jan-2008' AND DEPT_CD = 124) AND  ( seqno = 1 OR seqno = (SELECT MAX(seqno) FROM ACS_DATA WHERE empno = a.empno AND opdate = a.opdate) ) ORDER BY empno")

i have need another type of help for read date of previous months if current months is feb than select jan like 1-jan-2008 if case is not jan always select day from 1 months prev year current
thanks

[idsanjeev]

hello
Thanks i got it working thats my need
thanks again
for nice support