Need example of TCC functions firstValue, overRows, overValues

Summary

Need example of TCC functions firstValue, overRows, overValues

Content

Within a database query I can use FIRST_VALUE and an OVER clause so I understand their concept but I can't seem to make the TCC functions firstValue, overRows, overValues work with a TCC script even in the simplest of cases.  Does anyone have an example with one (or all) of these in it?

Thanks in advance.