Write a list of the last function accepts list and returns the last element of the function, if the list is empty, return none

CodePudding user response:

The system has LAST_VALUE function

CodePudding user response:

No list, the SQL Server is table, if you are using table, then directly with built-in last_value
If you are expressed in other ways the list, then see you specific use what way to represent (string, XML, json, or other)