Last unique inserted row

[Anonymous]

I need to retrieve the last inserted row for unique set of columns Got a table with AutoIncrement , Position , status , dateTime where position is a nr form 1 to 20 and status a nr from 1 to 50 The table get updated continuously and I need to now the last status for every position

[miah alom]

select * from ctm group by AutoIncrement having Position = max(Position) and Status = Max(Status) should do it.

[toxcct]

select * from mytable where myColumn = @@IDENTITY

see here[^] for more details

---

TOXCCT >>> GEII power
[toxcct][VisualCalc]