Database

Select empName, Sum(Cast(HoursWorked as int))
From tablename
Group by empName

Select empName, HoursWorked = Sum(DateDiff(ss, LoginTime, LogoutTime)) / 3600
From login
Group by empName

<br />
Select ProductID, Max(Date)<br />
Group by ProductID<br />

SELECT * FROM my_table 
    INNER JOIN 
        (SELECT product_id, MAX(date_field) 
         FROM my_table GROUP BY product_id) 
    AS inner_table 
    ON my_table.product_id = inner_table.product_id

"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar

The Second EuroCPian Event will be in Brussels on the 4th of September

Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!

My Blog