Skip to content

Instantly share code, notes, and snippets.

@josephwambura

josephwambura/TheRowWithLongest.sql

Created March 24, 2022 14:29
Show Gist options
  • Save josephwambura/58a8068bdcea74aa4b33f63594b2caf4 to your computer and use it in GitHub Desktop.
Save josephwambura/58a8068bdcea74aa4b33f63594b2caf4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
TheRowWithLongest.sql
SELECT TOP 1 SubjectAdditionalData, * FROM AuditLog
WHERE
len(SubjectAdditionalData) =
(SELECT max(len(SubjectAdditionalData)) FROM AuditLog);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment