Display Second Largest Value

Posted on By David Kittell 
SELECT MAX(col)
FROM TABLE
WHERE col < (
		SELECT MAX(col)
		FROM TABLE
		)
Originally Posted on June 26, 2014
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL

Related Posts

PowerShell – Install Ubuntu WSL (Linux On Windows)

Posted on

If you have issues like I have had with the Windows Store this will help you to get Ubuntu WSL on Windows. NOTE: You may need to reboot your computer after the first line. Enable-WindowsOptionalFeature -Online -FeatureName Microsoft-Windows-Subsystem-Linux #Install-WindowsFeature -Name Microsoft-Windows-Subsystem-Linux Invoke-WebRequest -Uri https://aka.ms/wsl-ubuntu-1604 -OutFile ~/Downloads/ubuntu-1604.zip New-Item -Path c:\ubuntu-1604 -ItemType…

Read More

DNN – Rename Admin User

Posted on

SET NOCOUNT ON DECLARE @OldUsername nvarchar(100), @NewUsername nvarchar(100) SET @OldUsername = ‘dkittell1’ SET @NewUsername = ‘dkittell’ UPDATE dnn_Users SET [Username] = @NewUsername WHERE [Username] = @OldUsername; UPDATE aspnet_Users SET [LoweredUserName] = @NewUsername WHERE [LoweredUserName] = @OldUsername; UPDATE aspnet_Users SET [UserName] = @NewUsername WHERE [UserName] = @OldUsername; UPDATE dnn_EventLog SET [LogUserName]…

Read More

Create SQLite Database With Auto Increment

Posted on

Sub CreateTable(SQL As SQL, TableName As String, FieldsAndTypes As Map, PrimaryKey As String, Auto As Boolean) Dim sb As StringBuilder sb.Initialize sb.Append("(") For i = 0 To FieldsAndTypes.Size – 1 Dim field, ftype As String field = FieldsAndTypes.GetKeyAt(i) ftype = FieldsAndTypes.GetValueAt(i) If i > 0 Then sb.Append(", ") sb.Append("[").Append(field).Append("] ").Append(ftype)…

Read More