Query to find the second lowest column value in a table

In this ms sql server tutorial you will learn query to find the second lowest column value in a table. Let’s have a look over the query that will give you second lowest column value in a table.

SELECT ColumnName FROM TableName WHERE ColumnName =
( SELECT MIN(ColumnName) FROM TableName WHERE
ColumnName>(SELECT MIN(ColumnName) FROM TableName))

Replace ColumnName with the Name of your table’s column and replace TableName with the name of your table.

So this is the query to find the second lowest column value in a table.