(Dan Clamage) I have a table called ENTITY with columns srcID, entID, occurrence and histflag. I want to get the rows with the max value in column ‘occurrence’ for each entID. I have accomplished this with the following:
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help