amillyard
asked on
sql get latest unique
what to retrieve a unique count of records ... when an db update is processed an new copy of the record is actioned (to preserve this historic data) ... so for example, the same account details may appear 3 or 4 times already ...but only want to count the latest copy.
there is also a DateTimeStamp column available (when table created / add to db)
need to also group results by ColumnValue item (there will be a bunch of denominations) -- but the frequency each of those occur ... and then finally a grand total of Frequency at the bottom.
how do you script this in SQL please?
USE db1
SELECT COUNT(Index_ID) AS Frequency
FROM dbo.Table1
WHERE (MySearchCriteria_ID <> 123) AND .....
GROUP BY DenominationValue
then display at bottom: GrandFreqTotal
there is also a DateTimeStamp column available (when table created / add to db)
need to also group results by ColumnValue item (there will be a bunch of denominations) -- but the frequency each of those occur ... and then finally a grand total of Frequency at the bottom.
how do you script this in SQL please?
USE db1
SELECT COUNT(Index_ID) AS Frequency
FROM dbo.Table1
WHERE (MySearchCriteria_ID <> 123) AND .....
GROUP BY DenominationValue
then display at bottom: GrandFreqTotal
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
the above line is not compiling - is this because there is an assumption there is column in table called: GrandFreqTotal
the group by list -- how do I also display the column label (or custom label) -- as currently there is just a set of figures (not easy to work out what each line is a result for).
i.e. the unique column value to be display (currently, the frequency of that value is being displayed)