how to get latest usage time per pc

[batmanAgen]

hi, i have a table softwareMeter(id [primarykey], pcID, softID, myDateTime). what is the query to get the last usage of the software per pc?

[kageorge]

Hi Just have a try with the below code Create Table #softwareMeter(id Int primary key, pcID Int, softID Int, myDateTime DateTime) Insert Into #softwareMeter Values (1,100,501,'20060301 10:12') Insert Into #softwareMeter Values (2,102,509,'20060301 12:40') Insert Into #softwareMeter Values (3,100,503,'20060302 08:12') Insert Into #softwareMeter Values (4,102,508,'20060302 13:50') Insert Into #softwareMeter Values (5,103,508,'20060303 13:50') Insert Into #softwareMeter Values (6,104,509,'20060303 15:20') Insert Into #softwareMeter Values (7,105,503,'20060303 18:13') **select top 10 with ties PCID,max(MyDateTime) from #softwareMeter Group by PCID Order By PCID** The top close is a must and the number after top should be set wisely.

[batmanAgen]

hey thanks for the reply... and for giving me the sql command.. thanks alot..:D i appreciate it!:)