Please help me I am not good in sql queries.
I have a view like this.
SNo Employee title Cdate IN TIME OUT TIME
258 john accountant 27/01/2008 7:28:12
258 john accountant 27/01/2008 7:28:30
258 john accountant 27/01/2008 16:03:42
258 john accountant 27/01/2008 16:03:48
258 john accountant 28/01/2008 7:36:42
258 john accountant 28/01/2008 7:36:51
258 john accountant 28/01/2008 16:05:24
258 john accountant 28/01/2008 16:05:30
Now i need to solve the following problem
to find the min(time) for a particular date
and max of the same date
and as a single raw for th particular date
staffNo Employee title Cdate IN TIME OUT TIME
258 john accountant 27/01/2008 7:28:12 16:03:48
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!