Hi all,

I do have an audit table with this structure:

AuditID
ChangeDate
RowID           (foreign/primary key in TableName)
ActionType   
TableName

and I want to query for records pertaining to a certain table name within a 
given changedate range.
I do, however, only want to receive the last (ChangeDate) record in cases where 
more than one record 
per rowid exist.

Any help appreciated,

Thanks,
Kai



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to