Tag Archives: SQL

How to select largest records in a group from a table

Theory is: – We need a field with unique value (such as: CreatedDateTime, Voucher Num, or an amount – select top 1) – Use Max (or Min) function to get what value you want. – Group by fields Example: Select … Continue reading

Posted in Select stament, SQL | Tagged , | 1 Comment