Example for Microsoft SQL Server:
select distinct
CE.Emp_Name,
(select min(Emp_Time) from Raw_Record As MINCE where MINCE.Emp_Type ='In' and MINCE.Emp_Name=CE.Emp_Name AND CONVERT(varchar(8),MINCE.EMP_TIME,112)=CONVERT(varchar(8),CE.Emp_Time,112)) As MinTime,
(select max(Emp_Time) from Raw_Record As MAXCE where MAXCE.Emp_Type ='Out' and MAXCE.Emp_Name=CE.Emp_name AND CONVERT(varchar(8),MAXCE.EMP_TIME,112)=CONVERT(varchar(8),CE.Emp_Time,112)) As MaxTime
from Raw_Record As CE
MINCE
(Minimum ClockEvents) is table_alias for Raw_Record table used in selection of Minimum Time.
MAXCE
(Maximum ClockEvents) is table_alias for Raw_Record table used in selection of Maximum Time.
CE
(ClockEvents) is table_alias for Raw_Record table used in main SELECT statement.