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 – Azure – Get VM Image List

Posted on

When installing a new VM in Azure it’s helpful to know your options Get-AzureVMImage | Select OS, label ( Get-AzureVMImage | where-object { $_.Label -like "Barracuda*" } ) | Fl OS, publishername, Location, logicalsizeinGB, Label, ImageFamily, ImageName ( Get-AzureVMImage | where-object { $_.Label -like "CentOS*" } ) | Fl OS,…

Read More

SQL Connection Test

Posted on

Imports System.Data.SqlClient Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim SqlConn As New SqlConnection Dim SqlConnStr As String = "Server=<Server Name/IP>;Database=<Database Name>;Integrated Security=True" If SqlConn.State = ConnectionState.Closed Then SqlConn.ConnectionString = SqlConnStr Try SqlConn.Open() MessageBox.Show("Succsessfull DB Connnection", "DB Connection Test", MessageBoxButtons.OK, MessageBoxIcon.Information) Catch…

Read More

GitLab – Site looks funky – CSS Issue

Posted on

It’s rare with the latest updates but sometimes the CSS doesn’t seem to load, this code may help if/when you run into the problem #!/bin/sh # FixGitLabCSS.sh # # This script will fix CSS and GUI related issues. # # Created by David Kittell on 11/2/16. # clear if […

Read More