Hi
bandi
Not working
My test data this
--Insert into Employee2 values(1,'AAA1','Male','02/02/1981','05/05/2002','Software Programmer1',12850.25,101)
--Insert into Employee2 values(2,'AAA2','FeMale','07/02/1981','06/05/2002','Software Programmer2',12850.25,102)
--Insert into Employee2 values(3,'AAA3','Male','09/02/1981','07/05/2002','Software Programmer3',12850.25,103)
--Insert into Employee2 values(4,'AAA4','FeMale','12/02/1981','08/05/2002','Software Programmer4',12850.25,101)
--Insert into Department2 values(101,'Software'),(102,'Hardware'),(104,'HR'),(103,'Production')
--Insert into Project values(1,'Sales Management system',101),(2,'School Management system',102),(3,'Accounts Management system',103)
--Insert into Worksfor VALUES(1,2,'02/03/1981',60),(2,3,'04/02/2013',40),(3,4,'07/02/2013',20)
--Insert into Worksfor VALUES(4,2,'08/03/1981',20),(5,3,'04/02/2013',60),(6,4,'07/02/2013',35)
My Question this
1.who have worked in more than three projects on a day.
based calculation hours column
ProNi column just enter number value thats it
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com
Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator